Re: [PATCH] Make pg_basebackup configure and start standby
Fujii Masao <masao.fujii@gmail.com>
From: Fujii Masao <masao.fujii@gmail.com>
To: Boszormenyi Zoltan <zb@cybertec.at>
Cc: pgsql-hackers@postgresql.org, Hans-Jürgen Schönig <hs@cybertec.at>
Date: 2012-07-01T16:01:43Z
Lists: pgsql-hackers
On Mon, Jul 2, 2012 at 12:42 AM, Boszormenyi Zoltan <zb@cybertec.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@cybertec.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? Regards, -- Fujii Masao