stupid question on setting up archive_command before creating pg_rman backup catalog

41 views
Skip to first unread message

Ken

unread,
Feb 8, 2012, 2:14:57 PM2/8/12
to pg_rman
The documentation says:
It is recommended to setup archive_mode and archive_command in
postgresql.conf before initialize the backup catalog

What should they be set to? Archive_mode is usually set to
"archive". Does archive_command just be set to "" (empty string) so
that pg_rman can set those variables?

Ken

unread,
Feb 8, 2012, 3:31:34 PM2/8/12
to pg_rman
Figured it out...

You should set up a directory owned by postgres for your archive log
backups. e.g., /home/postgres/arclog
Then in your postgresql.conf, it should read:
archive_command = 'cp "%p" "/home/postgres/arclog/%f"'
Ideally, these are placed on a separate drive from your data drive for
backup protection. And backups should be done to a different drive as
well, then you can rsync it off to a different server.

BTW, there's a bug in the documentation. This line:
-b { full | incremental | archive } / --backup-mode={ full |
incremental | archive }
Should be:
-b { f | i | a } / --backup-mode={ full | incremental | archive }
Reply all
Reply to author
Forward
0 new messages