If you change a user's redshift password, will any pre-existing connections for that user remain valid?

Question

Suppose I have a Redshift user 'person1' with password 'oldpassword', and I have a few existing open Redshift connections using these credentials. I then run the following command:

alter user person1 password 'newpassword'

For any new connections, I will of course have to use the new credentials 'person1' and 'newpassword'. But will the already existing connections remain valid, or will they suddenly stop working after this command?

Thank you so much!

Answer 1

Changing the password will not immediately terminate ongoing connections. The superuser can manually do that with PG_TERMINATE_BACKEND, if needed.