From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
To: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: Andrew W. Gibbs <awgibbs@awgibbs.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: base backup requirements for PITR
Date: Mon, 03 Dec 2012 10:24:17 +0100
Message-ID: <50BC6FC1.20208@2ndQuadrant.it> (raw)
In-Reply-To: <D960CB61B694CF459DCFB4B0128514C208C99DF4@exadv11.host.magwien.gv.at>
References: <20121129015217.GA9975@raptor.commandosoftware.com>
<50B936E9.9090504@2ndQuadrant.it>
<D960CB61B694CF459DCFB4B0128514C208C99DF4@exadv11.host.magwien.gv.at>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi Laurenz,
Il 01/12/12 12:18, Albe Laurenz ha scritto:
> Gabriele, I understand that you want to spread the word,
> but the OP's problem was a different one:
You are right. I totally missed that. I skimmed the email (very quickly)
and thought that in that particular context Andrew was referring to PITR
in general.
> He wants to create a base backup by just copying the
> data directory of an 8.4 warm standby server.
> There is no possibility to run pg_(start|stop)_backup,
> but the documentation seems to suggest that it could work
> anyway:
> http://www.postgresql.org/docs/8.4/static/warm-standby.html#BACKUP-INCREMENTAL-UPDATEDYes, it is possible. I'd like to try and implement that in Barman, in
order to automate this. I'd try and follow this path though:
pg_start_backup() on the master, wait for the operation to be replayed
on the standby (with pg_controldata if < 9.0 or through hot standby),
rsync/tar from the standby, then pg_stop_backup() on the master. If you
think of following this path yourself, please make sure you test it
accurately (especially for production environment).
Sorry Andrew about misunderstanding the original question.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it
--
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: gabriele.bartolini@2ndQuadrant.it, laurenz.albe@wien.gv.at, awgibbs@awgibbs.com
Subject: Re: base backup requirements for PITR
In-Reply-To: <50BC6FC1.20208@2ndQuadrant.it>
* 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