Re: Using pg_start_backup() and pg_stop_backup() - using 9.1.2.2 - Mailing list pgsql-general

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@aklaver.com