On 06/14/2014 06:44 AM, Khangelani Gama wrote:
Hi all

Please help me here.


I would say the best way to help is to figure out what it is you want out of the master/standby/archive setup before getting into the actual configuration.

What do you want to do with the standby/archive?

1) Do you want streaming replication?

2) Have backup database to query/backup from? In other words a Hot Standby.

3) Have an archive to do Point in Time Recovery(PITR)?

4) Have an archive as a backup in case streaming replication goes down?

5) Do you even need an archive or is streaming WAL files enough?




--
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

Reply via email to