From: | salman <salmanb(at)quietcaresystems(dot)com> |
---|---|
To: | libra dba <libra(dot)dba(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? |
Date: | 2008-02-27 21:05:47 |
Message-ID: | 47C5D0AB.7070102@quietcaresystems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)rhostname:/usr/local/postgresql/archives/recovery/%f.gz && rm
-f %p.gz'
From | Date | Subject | |
---|---|---|---|
Next Message | Tena Sakai | 2008-02-28 01:12:40 | trouble with pg_dumpall |
Previous Message | libra dba | 2008-02-27 20:54:07 | Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? |