Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] Make pg_basebackup configure and start standby

From: Boszormenyi Zoltan <zb(at)cybertec(dot)at>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Hans-Jürgen Schönig <hs(at)cybertec(dot)at>
Subject: Re: [PATCH] Make pg_basebackup configure and start standby
Date: 2012-10-03 12:38:05
Message-ID: 506C31AD.1070004@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-hackers
2012-07-01 18:01 keltezéssel, Fujii Masao írta:
> On Mon, Jul 2, 2012 at 12:42 AM, Boszormenyi Zoltan <zb(at)cybertec(dot)at> wrote:
>> Hi,
>>
>> 2012-07-01 17:38 keltezéssel, Fujii Masao írta:
>>
>>> On Sun, Jul 1, 2012 at 8:02 PM, Boszormenyi Zoltan <zb(at)cybertec(dot)at> wrote:
>>>> Hi,
>>>>
>>>> attached is a patch that does $SUBJECT.
>>>>
>>>> It's a usability enhancement, to take a backup, write
>>>> a minimalistic recovery.conf and start the streaming
>>>> standby in one go.
>>>>
>>>> Comments?
>>> Could you add the patch to the next CommitFest?
>>
>> I will.
>>
>>
>>> If the backup is taken from the standby server, the standby's
>>> recovery.conf
>>> is included in the backup. What happens in this case?
>>
>> As documented, the command line parameters of pg_basebackup
>> will be used for recovery.conf. So, the new standby will replicate
>> the previous one. Cascading replication works since 9.2.
> So pg_basebackup overwrites the recovery.conf which was backed up
> from the standby with the recovery.conf which was created by using
> the command line parameters of pg_basebackup?

Only if requested.

Best regards,
Zoltán Böszörményi

-- 
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
      http://www.postgresql.at/



In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2012-10-03 12:49:31
Subject: Re: PATCH: pgbench - random sampling of transaction written into log
Previous:From: Fabrízio de Royes MelloDate: 2012-10-03 12:27:41
Subject: Re: CREATE SCHEMA IF NOT EXISTS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group