Re: Taking rsynced base-backup without wal-archiving enabled

Поиск
Список
Период
Сортировка
От Rene Romero Benavides
Тема Re: Taking rsynced base-backup without wal-archiving enabled
Дата
Msg-id CANaGW08e9=R-FGTrKvTYO54HygBd5mk=OOvPF052_PbXTFLonw@mail.gmail.com
обсуждение исходный текст
Ответ на Taking rsynced base-backup without wal-archiving enabled  (Jürgen Fuchsberger <juergen.fuchsberger@gmx.at>)
Ответы Re: Taking rsynced base-backup without wal-archiving enabled
Список pgsql-general
Дерево обсуждения
It depends on the database transactional activity,
observe how many new wal files are generated during a period equivalent to what it takes to do your base backup. I would set it to twice that number. Take into account that a checkpoint is issued at the beginning of the process. If you're lazy just try setting it to something very high such as 256 or more to prevent wal files being recycled during the process.


2014-06-23 2:12 GMT-05:00 Jürgen Fuchsberger <juergen.fuchsberger@gmx.at>:
Hi all,

Can I do a consistent file-system-level backup using the following
procedure:

1) SELECT pg_start_backup(...)
2) rsync postgres data dir to another server
3) SELECT pg_stop_backup()
4) rsync pg_xlog directory

From what I understand this should be similar to running pg_basebackup
using the -x parameter, correct? One caveat seems to be that
wal_keep_segments should be set "high enough". Can anybody tell what
"high enough" usually is?

Thanks in advance for you help!

Best regards,
Juergen




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

В списке pgsql-general по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: skipping analyze of "table1" --- lock not available?
Следующее
От: Дмитрий Голубь
Дата:
Сообщение: if row has property X, find all rows that has property X