Skip site navigation (1) Skip section navigation (2)

Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

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 (view raw or flat)
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'





In response to

Responses

pgsql-admin by date

Next:From: Tena SakaiDate: 2008-02-28 01:12:40
Subject: trouble with pg_dumpall
Previous:From: libra dbaDate: 2008-02-27 20:54:07
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group