Changing postgres user password in a master-slave setup
- by NRS
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.