From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | AC Gomez <antklc(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: what happens when you issue ALTER SERVER in a hot environment? |
Date: | 2020-04-07 04:29:37 |
Message-ID: | CAKFQuwY=XfZns9Yu9Uv9doytAK6Aws=z-jgVKB55todjAbAMyQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Monday, April 6, 2020, AC Gomez <antklc(at)gmail(dot)com> wrote:
> If you issue an ALTER SERVER command and there are active connections
> with that server in use or new ones are coming in, what happens? Docs on
> this command say nothing regarding active processing using the server
> context and changes to it. So I assume it's just handled.
>
Not sure if there are exceptions but assume that nothing external will
change your current active session’s settings out from underneath you.
> For example if you alter user/password, I assume that as long as prior
> user password is still good that actively running processes will keep going.
>
If you alter a password the old one is by definition no longer good...but
it doesn’t matter because authentication only happens once - during login.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-04-07 04:53:11 | Re: what happens when you issue ALTER SERVER in a hot environment? |
Previous Message | AC Gomez | 2020-04-07 04:08:15 | what happens when you issue ALTER SERVER in a hot environment? |