I was reading through this: http://www.postgresql.org/about/ And I saw this: An enterprise class database, PostgreSQL boasts sophisticated features such as ... point in time recovery I need some light shed on this subject and its features and examples of it in action or share their own performance experiences? ...
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 c...
Is there any documentation on gracefully restarting servers that have PITR implemented. We have a master-slave setup. I want to make sure servers are rebooted in the correct order so as not to mess up WAL shipping. Should i disable WAL shipping prior to server restart? ...