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.
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
postgres(at)rhostname:/usr/local/postgresql/archives/recovery/%f.gz && rm
In response to
pgsql-admin by date
|Next:||From: Tena Sakai||Date: 2008-02-28 01:12:40|
|Subject: trouble with pg_dumpall|
|Previous:||From: libra dba||Date: 2008-02-27 20:54:07|
|Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?|