pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCross-site cookies warnings
7+ messages / 5 participants
[nested] [flat]
* Cross-site cookies warnings
@ 2020-07-15 13:34 Fabio <banifabio@tiscali.it>
0 siblings, 1 reply; 7+ messages in thread
From: Fabio @ 2020-07-15 13:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I'm using python 3.7.4, django 3.0.6, javascript, Postgres 12.3.1
pgadmin 4.21 windows7. When my page loads on the console there are these
warnings:
|Cookie“PGADMIN_KEY”will be soon treated ascross-site cookie against
“http://127.0.0.1:8000/lists/list-name/” because the scheme does not
match. list-nameCookie“PGADMIN_LANGUAGE”will be soon treated
ascross-site cookie against “http://127.0.0.1:8000/lists/list-name/”
because the scheme does not match. list-nameCookie“PGADMIN_KEY”will be
soon treated ascross-site cookie against
“http://127.0.0.1:8000/lists/list-name/” because the scheme does not
match. list-nameCookie“PGADMIN_LANGUAGE”will be soon treated
ascross-site cookie against “http://127.0.0.1:8000/lists/list-name/”
because the scheme does not match. list-nameCookie“PGADMIN_KEY”will be
soon treated ascross-site cookie against
“http://127.0.0.1:8000/static/lists/js/lists.js” because the scheme does
not match. lists.jsCookie“PGADMIN_LANGUAGE”will be soon treated
ascross-site cookie against
“http://127.0.0.1:8000/static/lists/js/lists.js” because the scheme does
not match. lists.jsCookie“PGADMIN_KEY”will be soon treated ascross-site
cookie against “http://127.0.0.1:8000/jsi18n/” because the scheme does
not match. jsi18nCookie“PGADMIN_LANGUAGE”will be soon treated
ascross-site cookie against “http://127.0.0.1:8000/jsi18n/” because the
scheme does not match. jsi18nCookie“PGADMIN_KEY”will be soon treated
ascross-site cookie against “http://127.0.0.1:8000/static/js/common.js”
because the scheme does not match. common.jsCookie“PGADMIN_LANGUAGE”will
be soon treated ascross-site cookie against
“http://127.0.0.1:8000/static/js/common.js” because the scheme does not
match. common.jsCookie“PGADMIN_KEY”will be soon treated ascross-site
cookie against “http://127.0.0.1:8000/static/icons/favicon.png” because
the scheme does not match. favicon.pngCookie“PGADMIN_LANGUAGE”will be
soon treated ascross-site cookie against
“http://127.0.0.1:8000/static/icons/favicon.png” because the scheme does
not match. favicon.png |They should come from thenew policy about cookies <https://blog.chromium.org/2019/10/developers-get-ready-for-new.html;. The problem is|PGADMIN_KEY| and|PGADMIN_LANGUAGE| are cookies of PGAdmin and I don't use
them explicitly (I mean evidently the database himself use them but
in my code they don't appear). Is this a bug of pgadmin?
Then I upgraded to pgadmin 4.23 and now I have only these warnings:
Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
“http://127.0.0.1:8000/lists/list-name/” because the scheme does not
match. 2 list-name <http://127.0.0.1:8000/lists/list-name/;
Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
“http://127.0.0.1:8000/jsi18n/” because the scheme does not match.
jsi18n <http://127.0.0.1:8000/jsi18n/;
Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
“http://127.0.0.1:8000/static/js/common.js” because the scheme does not
match. common.js <http://127.0.0.1:8000/static/js/common.js;
Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
“http://127.0.0.1:8000/static/lists/js/lists.js” because the scheme does
not match. lists.js <http://127.0.0.1:8000/static/lists/js/lists.js;
Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
“http://127.0.0.1:8000/static/icons/favicon.png” because the scheme does
not match. favicon.png <http://127.0.0.1:8000/static/icons/favicon.png;
Also I see a new cookie (PGADMIN_INT_KEY) but it doesn't give problems.
So there's some way to solve this problem or I just have to wait the new update?
thank you
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Cross-site cookies warnings
@ 2020-07-15 17:37 Holger Jakobs <holger@jakobs.com>
parent: Fabio <banifabio@tiscali.it>
0 siblings, 0 replies; 7+ messages in thread
From: Holger Jakobs @ 2020-07-15 17:37 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Wrong list. This one is about PostgreSQL, and NOT pgAdmin.
Am 15.07.20 um 15:34 schrieb Fabio:
>
> I'm using python 3.7.4, django 3.0.6, javascript, Postgres 12.3.1
> pgadmin 4.21 windows7. When my page loads on the console there are
> these warnings:
>
> |Cookie“PGADMIN_KEY”will be soon treated ascross-site cookie against
> “http://127.0.0.1:8000/lists/list-name/” because the scheme does not
> match. list-nameCookie“PGADMIN_LANGUAGE”will be soon treated
> ascross-site cookie against “http://127.0.0.1:8000/lists/list-name/”
> because the scheme does not match. list-nameCookie“PGADMIN_KEY”will be
> soon treated ascross-site cookie against
> “http://127.0.0.1:8000/lists/list-name/” because the scheme does not
> match. list-nameCookie“PGADMIN_LANGUAGE”will be soon treated
> ascross-site cookie against “http://127.0.0.1:8000/lists/list-name/”
> because the scheme does not match. list-nameCookie“PGADMIN_KEY”will be
> soon treated ascross-site cookie against
> “http://127.0.0.1:8000/static/lists/js/lists.js” because the scheme
> does not match. lists.jsCookie“PGADMIN_LANGUAGE”will be soon treated
> ascross-site cookie against
> “http://127.0.0.1:8000/static/lists/js/lists.js” because the scheme
> does not match. lists.jsCookie“PGADMIN_KEY”will be soon treated
> ascross-site cookie against “http://127.0.0.1:8000/jsi18n/” because
> the scheme does not match. jsi18nCookie“PGADMIN_LANGUAGE”will be soon
> treated ascross-site cookie against “http://127.0.0.1:8000/jsi18n/”
> because the scheme does not match. jsi18nCookie“PGADMIN_KEY”will be
> soon treated ascross-site cookie against
> “http://127.0.0.1:8000/static/js/common.js” because the scheme does
> not match. common.jsCookie“PGADMIN_LANGUAGE”will be soon treated
> ascross-site cookie against
> “http://127.0.0.1:8000/static/js/common.js” because the scheme does
> not match. common.jsCookie“PGADMIN_KEY”will be soon treated
> ascross-site cookie against
> “http://127.0.0.1:8000/static/icons/favicon.png” because the scheme
> does not match. favicon.pngCookie“PGADMIN_LANGUAGE”will be soon
> treated ascross-site cookie against
> “http://127.0.0.1:8000/static/icons/favicon.png” because the scheme
> does not match. favicon.png |They should come from the new policy about cookies <https://blog.chromium.org/2019/10/developers-get-ready-for-new.html;. The problem is |PGADMIN_KEY| and |PGADMIN_LANGUAGE| are cookies of PGAdmin and I don't use
> them explicitly (I mean evidently the database himself use them but
> in my code they don't appear). Is this a bug of pgadmin?
>
>
> Then I upgraded to pgadmin 4.23 and now I have only these warnings:
>
>
> Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
> “http://127.0.0.1:8000/lists/list-name/” because the scheme does not
> match. 2 list-name <http://127.0.0.1:8000/lists/list-name/;
> Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
> “http://127.0.0.1:8000/jsi18n/” because the scheme does not match.
> jsi18n <http://127.0.0.1:8000/jsi18n/;
> Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
> “http://127.0.0.1:8000/static/js/common.js” because the scheme does
> not match. common.js <http://127.0.0.1:8000/static/js/common.js;
> Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
> “http://127.0.0.1:8000/static/lists/js/lists.js” because the scheme
> does not match. lists.js <http://127.0.0.1:8000/static/lists/js/lists.js;
> Cookie “PGADMIN_KEY” will be soon treated as cross-site cookie against
> “http://127.0.0.1:8000/static/icons/favicon.png” because the scheme
> does not match. favicon.png
> <http://127.0.0.1:8000/static/icons/favicon.png;
> Also I see a new cookie (PGADMIN_INT_KEY) but it doesn't give problems.
> So there's some way to solve this problem or I just have to wait the new update?
>
> thank you
>
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
^ permalink raw reply [nested|flat] 7+ messages in thread
* Switchover
@ 2023-12-23 18:08 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 7+ messages in thread
From: Rajesh Kumar @ 2023-12-23 18:08 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi all,
Any idea what prerequisite I should follow before I use the command
patronictl switchover?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Switchover
@ 2023-12-28 05:38 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 2 replies; 7+ messages in thread
From: Rajesh Kumar @ 2023-12-28 05:38 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Do I have to take a downtime of few mns and stop the applications and do a
switchover?
What happens internally when we use the command patronictl switchover? Just
that the role is changed? Will it affect incoming connections?
On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com>
wrote:
> Hi all,
>
>
> Any idea what prerequisite I should follow before I use the command
> patronictl switchover?
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Switchover
@ 2023-12-28 13:10 kaido vaikla <kaido.vaikla@gmail.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 0 replies; 7+ messages in thread
From: kaido vaikla @ 2023-12-28 13:10 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Patroni communication channels:
https://patroni.readthedocs.io/en/latest/CONTRIBUTING.html#contributing
br
Kaido
On Thu, 28 Dec 2023 at 07:39, Rajesh Kumar <rajeshkumar.dba09@gmail.com>
wrote:
> Do I have to take a downtime of few mns and stop the applications and do a
> switchover?
>
> What happens internally when we use the command patronictl switchover?
> Just that the role is changed? Will it affect incoming connections?
>
> On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com>
> wrote:
>
>> Hi all,
>>
>>
>> Any idea what prerequisite I should follow before I use the command
>> patronictl switchover?
>>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Switchover
@ 2023-12-28 14:25 Scott Ribe <scott_ribe@elevated-dev.com>
parent: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Scott Ribe @ 2023-12-28 14:25 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
In my experience:
- Patroni switchover happens in a few seconds
- If you use pgbouncer, the client connections don't get dropped. A client that issues a query in that brief window will get an error.
- If your clients have retry logic, your users will never notice the failover.
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
> On Dec 27, 2023, at 10:38 PM, Rajesh Kumar <rajeshkumar.dba09@gmail.com> wrote:
>
> Do I have to take a downtime of few mns and stop the applications and do a switchover?
>
> What happens internally when we use the command patronictl switchover? Just that the role is changed? Will it affect incoming connections?
>
> On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com> wrote:
> Hi all,
>
>
> Any idea what prerequisite I should follow before I use the command patronictl switchover?
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Switchover
@ 2024-01-02 15:41 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 7+ messages in thread
From: Rajesh Kumar @ 2024-01-02 15:41 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Can I take a small downtime and stop all applications and switchover or
shall I simply switchover during low traffic time?
On Thu, 28 Dec 2023, 19:55 Scott Ribe, <scott_ribe@elevated-dev.com> wrote:
> In my experience:
>
> - Patroni switchover happens in a few seconds
> - If you use pgbouncer, the client connections don't get dropped. A client
> that issues a query in that brief window will get an error.
> - If your clients have retry logic, your users will never notice the
> failover.
>
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
> > On Dec 27, 2023, at 10:38 PM, Rajesh Kumar <rajeshkumar.dba09@gmail.com>
> wrote:
> >
> > Do I have to take a downtime of few mns and stop the applications and do
> a switchover?
> >
> > What happens internally when we use the command patronictl switchover?
> Just that the role is changed? Will it affect incoming connections?
> >
> > On Sat, 23 Dec 2023, 23:38 Rajesh Kumar, <rajeshkumar.dba09@gmail.com>
> wrote:
> > Hi all,
> >
> >
> > Any idea what prerequisite I should follow before I use the command
> patronictl switchover?
>
>
>
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-01-02 15:41 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-07-15 13:34 Cross-site cookies warnings Fabio <banifabio@tiscali.it>
2020-07-15 17:37 ` Holger Jakobs <holger@jakobs.com>
2023-12-23 18:08 Switchover Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-12-28 05:38 ` Re: Switchover Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-12-28 13:10 ` Re: Switchover kaido vaikla <kaido.vaikla@gmail.com>
2023-12-28 14:25 ` Re: Switchover Scott Ribe <scott_ribe@elevated-dev.com>
2024-01-02 15:41 ` Re: Switchover Rajesh Kumar <rajeshkumar.dba09@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox