Changing postgres user password in a master-slave setup

Posted by NRS on Stack Overflow See other posts from Stack Overflow or by NRS
Published on 2010-05-05T23:13:43Z Indexed on 2010/05/05 23:18 UTC
Read the original article Hit count: 474

Filed under:
|
|
|

We have PITR setup and WAL shipping enabled. We would like to change the password for the user postgres. The process is simple enough. However, since we cannot connect to the SLAVE how would we make sure all passwords are in synch? Would temporarily disabling WAL shipping allow me to connect to the slave to change the password there? I cant seem to find documentation on a clean way to implement this password change and I don't have a test environment.

© Stack Overflow or respective owner

Related posts about password

Related posts about change