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>)
Список 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 по дате отправления:

Предыдущее
От: Uwe Schroeder
Дата:
Сообщение: Re: Backups
Следующее
От: Jukka Inkeri
Дата:
Сообщение: Problem to use remote cygwin server using ssh and native psql 8.3.5