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)
Список
Дерево обсуждения
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 по дате отправления
От: Jukka Inkeri
Дата: