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

Reply via email to