Search Postgresql Archives

Taking rsynced base-backup without wal-archiving enabled

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux