On 11/19/2014 05:58 PM, zach cruise wrote:
i need some advice:
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?
Yes I am confused.
What replication method are you using?
The built in methods, Slony. Bucardo, etc?
The production users cannot enter or update records?
If you have replication set up master -> slave, how can there be a
difference between the two?
Not sure where the mssql databases into this?
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?
Answers for 2 & 3 are dependent on answers to the above questions.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
