Message-ID: <50BC6FC1.20208@2ndQuadrant.it>
Date: Mon, 03 Dec 2012 10:24:17 +0100
From: Gabriele Bartolini <gabriele.bartolini@2ndQuadrant.it>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
	rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: Albe Laurenz <laurenz.albe@wien.gv.at>
CC: "Andrew W. Gibbs" <awgibbs@awgibbs.com>, pgsql-admin@postgresql.org
Subject: Re: base backup requirements for PITR
References: <20121129015217.GA9975@raptor.commandosoftware.com>
	<50B936E9.9090504@2ndQuadrant.it>
	<D960CB61B694CF459DCFB4B0128514C208C99DF4@exadv11.host.magwien.gv.at>
In-Reply-To: 
 <D960CB61B694CF459DCFB4B0128514C208C99DF4@exadv11.host.magwien.gv.at>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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-UPDATED
Yes, 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