Postgres Pro
Downloads
Home   >   mailing lists

Re: what happens when you issue ALTER SERVER in a hot environment? - Mailing list pgsql-general

From David G. Johnston
Subject Re: what happens when you issue ALTER SERVER in a hot environment?
Date
Msg-id CAKFQuwY=XfZns9Yu9Uv9doytAK6Aws=z-jgVKB55todjAbAMyQ@mail.gmail.com
Whole thread Raw
In response to what happens when you issue ALTER SERVER in a hot environment?  (AC Gomez <antklc@gmail.com>)
Responses Re: what happens when you issue ALTER SERVER in a hot environment?
List pgsql-general
Tree view
On Monday, April 6, 2020, AC Gomez <antklc@gmail.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.

pgsql-general by date:

Previous
From: AC Gomez
Date:
Subject: what happens when you issue ALTER SERVER in a hot environment?
Next
From: Tom Lane
Date:
Subject: Re: what happens when you issue ALTER SERVER in a hot environment?