From: Dimitri Fontaine <dimitri@2ndQuadrant.fr>
To: Magnus Hagander <magnus@hagander.net>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Dimitri Fontaine <dimitri@2ndquadrant.fr>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Backup docs
Date: Fri, 15 Jun 2012 22:39:23 +0200
Message-ID: <m21ulgjon8.fsf@2ndQuadrant.fr> (raw)
In-Reply-To: <CABUevExc29GyW9359G_EN+3TrFj9buQ_JM6y8mcNobTDbhokgQ@mail.gmail.com>
References: <CABUevEx2NxgYV6FVZ7itmCvBcyLBfQbOLXMHqCceCyq_oAH1mw@mail.gmail.com>
<m2mx47ggrq.fsf@2ndQuadrant.fr>
<CA+Tgmob5BnswRhwYeWB_H9qOzAEojHrF_p4oxhrmthUTo7WNTQ@mail.gmail.com>
<CABUevExc29GyW9359G_EN+3TrFj9buQ_JM6y8mcNobTDbhokgQ@mail.gmail.com>
Magnus Hagander <magnus@hagander.net> writes:
> - The procedure for making a base backup is relatively simple:
> + The easiest way to perform a base backup is to use the
> + <xref linkend="app-pgbasebackup"> tool. It can create
> + a base backup either as regular files or as a tar archive. If more
> + flexibility than <xref linkend="app-pgbasebackup"> can provide is
> + required, you can also make a base backup using the low level API
> + (see <xref linkend="backup-lowlevel-base-backup">).
> + </para>
Good start.
> + <para>
> + It is not necessary to be concerned about the amount of time it takes
> + to make a base backup. However, if you normally run the
Why not?
> + file, and can ordinarily be ignored.) Once you have safely archived
> + the file system backup and the WAL segment files used during the
> + backup (as specified in the backup history file), all archived WAL
> + segments with names numerically less are no longer needed to recover
> + the file system backup and can be deleted. However, you should
> + consider keeping several backup sets to be absolutely certain that
> + you can recover your data.
> + </para>
You're frighting off users when not detailing, I think. How to be
certain I can recover my data, is there a way that I can't when a backup
has been successfully made? How can I check?
Also I don't see mention of basebackup+wal files all in one with the -x
option, which I though would have to be addressed here?
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
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-hackers@postgresql.org
Cc: dimitri@2ndQuadrant.fr, magnus@hagander.net, robertmhaas@gmail.com
Subject: Re: Backup docs
In-Reply-To: <m21ulgjon8.fsf@2ndQuadrant.fr>
* 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