From: Kevin Grittner <kgrittn@ymail.com>
To: girish R G peetle <giri.anamika0@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: PostgreSQL File System Based Backup Restartability
Date: Wed, 18 Feb 2015 15:29:30 +0000 (UTC)
Message-ID: <2057820533.544572.1424273370550.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <CAKKd065ZkmG1ftEptk5rDkQD_NbRhqz4cnBeao8bJ6jnjkCjmg@mail.gmail.com>
References: <CAKKd065ZkmG1ftEptk5rDkQD_NbRhqz4cnBeao8bJ6jnjkCjmg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
girish R G peetle <giri.anamika0@gmail.com> wrote:
> "Be careful that when you resume after such an interruption you
> do not skip any files and that you complete or re-copy any files
> that were partially copied before the problems."
>
> Here you mean, we should not skip any files that was already
> backed up before interruption ?
> I will have to backup entire content under DATA directory again ?
No.
Think of it this way: for every file that existed both when
pg_start_backup() and pg_stop_backup() were run, every OS-level
page must represent the state of that page at some point between
when those functions were run. *Which* point in time each page
represents is not important, and it is not expected that all files
(or all pages within a file) represent the same point in time. WAL
replay is guaranteed to fix up all pages modified between those
function executions. The backup_label file specifies which WAL
records are needed to do that.
There were two concerns I had with what you described.
(1) That when you resume with the 20th file, that is not an
ordinal position in a new list which might have fewer files ahead
of the 20th position, resulting in skipping some files. If you're
continuing to use the original list, using the position in that
list is fine.
(2) That if the error occurred part-way through reading a file,
leaving a portion uncopied, that the missing portion be copied.
(Of course re-copying the whole file works, too; but you could
safely resume just past the last page successfully copied before
the network problems.)
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: kgrittn@ymail.com, giri.anamika0@gmail.com
Subject: Re: PostgreSQL File System Based Backup Restartability
In-Reply-To: <2057820533.544572.1424273370550.JavaMail.yahoo@mail.yahoo.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