From: | zach cruise <zachc1980(at)gmail(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | better architecture? |
Date: | 2014-11-20 01:58:23 |
Message-ID: | CAL8icXwKyF3SiM+k+LCELqKmoQYYya9eNZPLNt-j7B1a_7qWzA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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?
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Sameer Kumar | 2014-11-20 02:26:13 | Re: how to delay sync by a set time, hour or day? |
Previous Message | John Smith | 2014-11-19 22:10:35 | Re: how to delay sync by a set time, hour or day? |