Search Postgresql Archives

Re: what happens when you issue ALTER SERVER in a hot environment?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Monday, April 6, 2020, AC Gomez <antklc@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux