Re: WAL shipping to two machines (PITR) - Mailing list pgsql-general

From Tomas Simonaitis
Subject Re: WAL shipping to two machines (PITR)
Date
Msg-id 200911081055.26489.tomas.simonaitis@gmail.com
Whole thread Raw
In response to WAL shipping to two machines (PITR)  (Geoffrey <lists@serioustechnology.com>)
List pgsql-general
We are using two slaves this way:

- Active server moves WAL files to local directory,
doesn't care about slaves
(basically archive_command = 'mv %p /some/arch_dir/%f')
- Slaves pull WAL files via rsync
- Slaves also do full syncs every several hours (pg_start_backup / rsync /
pg_stop_backup)
- Active server also has "cleanup daemon": removes redundant archived WALs
based on last full backup time

The slaves are not warm,
however they periodically create LVM snapshots and pg_dump databases.

pgsql-general by date:

Previous
From: Uwe Schroeder
Date:
Subject: Re: Backups
Next
From: Jukka Inkeri
Date:
Subject: Problem to use remote cygwin server using ssh and native psql 8.3.5