Standalone Hot Backups

From: Sergey Arlashin <sergeyarl(dot)maillist(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Standalone Hot Backups
Date: 2013-08-21 17:35:23
Message-ID: 1506B870-FE7D-4A13-B7BF-700F33BE9FC6@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Poole 2013-08-21 18:52:03 Re: Standalone Hot Backups
Previous Message Matheus de Oliveira 2013-08-21 12:54:22 Re: incomplete startup packet