1. for our small business, i have a master (dev) - slave (prod) setup.
i develop using the master. i get data from other people's dev (mssql) databases. i also get data from their prod (mssql) databases. i replicate everything on slave.
apps using the master can connect only to dev databases, and apps using the slave can connect only to prod databases. so when it's time to go from dev to prod, i simply change that connection. no restart.
comments?
2. what happens if master-slave are rebooted at different times?
3. i also need to auto-promote slave to master if master fails (without using repmgr or postgres-r or even postgres-xl). how?