| 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: | Whole Thread | Raw Message | 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? |