Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? - Mailing list pgsql-admin

From salman
Subject Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Date
Msg-id 47C5D0AB.7070102@quietcaresystems.com
Whole thread Raw
In response to Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?  ("Praveen Kumar \(TUV\)" <praveen.k@renaissance-it.com>)
Responses Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
List pgsql-admin

libra dba wrote:
> continuing with the postgres replication using WARM STANDBY, what happens to
> the wal_files which keeps on generating on the primary?
>
> Do we have to manually remove them or they are removed automatically, once
> they have been recovered on the warm standby?
>
> Also a quick question, do we have to have a NFS for the wal_files, which
> will be mounted on both the servers, or we can have folders on each server
> and configure DRBD between them, so that whatever happens on one is copied
> automatically on to the other.
>
> Thanks!
>

This is what I use -- may not be the best approach, but it has worked
quite well for me so far:

archive_command = 'gzip %p; rsync -av %p.gz -e \"ssh -p portNum -i
/home/postgres/.ssh/id_dsa\"
postgres@rhostname:/usr/local/postgresql/archives/recovery/%f.gz && rm
-f %p.gz'





pgsql-admin by date:

Previous
From: Lew
Date:
Subject: Re: how do I get table DDL from psql (not from pg_dump)
Next
From: "libra dba"
Date:
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?