On 12/01/2015 09:16 AM, anj patnaik wrote:
Thanks for the info Scott.
Can I setup a primary server called A that uses the Postgres
installation on a nfs mounted filesystem and then A does a daily backup
of database A and restores to database B on same filesystem.
Then I have server B acting as cold standby and if server A goes down,
then B would make the backup DB active?
In this case, both server A and B have the same NFS mount, but B is not
always writing to the data.
The target environment I am moving to is a RAID5 system with mirrored
discs. I will be getting a VM on a physical server and the mirrored
disks will store the database. I would like to setup a primary and
secondary as cold standby.
I am fairly new to PG so asking these questions.
Please advise. Thank you.
Advice, read these pages:
http://www.postgresql.org/docs/9.4/interactive/tutorial-arch.html
http://www.postgresql.org/docs/9.4/interactive/creating-cluster.html
http://www.postgresql.org/docs/9.4/interactive/warm-standby.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
