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(dot)klaver(at)aklaver(dot)com