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.klaver@xxxxxxxxxxx
