From: Sergey Arlashin <sergeyarl.maillist@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Standalone Hot Backups
Date: Wed, 21 Aug 2013 21:35:23 +0400
Message-ID: <1506B870-FE7D-4A13-B7BF-700F33BE9FC6@gmail.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi!
I'm reading this article http://www.postgresql.org/docs/current/static/continuous-archiving.htm
In section 'Making a Base Backup Using the Low Level API' is said that once one has WAL archiving set up it is ok to omit pg_xlog folder from the backup dump:
> "You can, however, omit from the backup dump the files within the cluster's pg_xlog/ subdirectory. This slight adjustment is worthwhile because it reduces the risk of mistakes when restoring. This is easy to arrange if pg_xlog/ is a symbolic link pointing to someplace outside the cluster directory, which is a common setup anyway for performance reasons. You might also want to exclude postmaster.pid and postmaster.opts, which record information about the running postmaster, not about the postmaster which will eventually use this backup. (These files can confuse pg_ctl.)"
But in section related to making standalone hot backups there is no information about it.
There is only the following set of commands:
touch /var/lib/pgsql/backup_in_progress
psql -c "select pg_start_backup('hot_backup');"
tar -cf /var/lib/pgsql/backup.tar /var/lib/pgsql/data/
psql -c "select pg_stop_backup();"
rm /var/lib/pgsql/backup_in_progress
tar -rf /var/lib/pgsql/backup.tar /var/lib/pgsql/archive/
I only can see that the backup folder is being archived with pg_xlog.
So, the question is - is it ok to omit pg_xlog folder from backup dump while making standalone hot backups or not ?
--
best regards,
Sergey=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sergeyarl.maillist@gmail.com
Subject: Re: Standalone Hot Backups
In-Reply-To: <1506B870-FE7D-4A13-B7BF-700F33BE9FC6@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox