Re: WAL shipping to two machines (PITR)

Поиск
Список
Период
Сортировка
Искать
От
Tomas Simonaitis
Тема
Re: WAL shipping to two machines (PITR)
Дата
Msg-id
200911081055.26489.tomas.simonaitis@gmail.com
Ответ на
Список
Дерево обсуждения
WAL shipping to two machines (PITR) Geoffrey <lists@serioustechnology.com>
Re: WAL shipping to two machines (PITR) Sam Mason <sam@samason.me.uk>
Re: WAL shipping to two machines (PITR) Tomas Simonaitis <tomas.simonaitis@gmail.com>
Re: WAL shipping to two machines (PITR) Geoffrey <lists@serioustechnology.com>
Re: WAL shipping to two machines (PITR) Geoffrey <lists@serioustechnology.com>
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 по дате отправления
От: Uwe Schroeder
Дата:
Сообщение: Re: Backups
От: Jukka Inkeri
Дата:
FAQ