pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Alexandra Wang <lewang@pivotal.io>
Cc: Sergei Kornilov <sk@zsrv.org>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: base backup client as auxiliary backend process
Date: Wed, 15 Jan 2020 16:20:35 +0100
Message-ID: <32bfb247-f65c-fb29-e062-f4f8f939d12a@2ndquadrant.com> (raw)
In-Reply-To: <CACiyaSqci=MhdEwVZEf=tUOdHfoEZPK9330ajhg5b750nPEenw@mail.gmail.com>
References: <61b8d18d-c922-ac99-b990-a31ba63cdcbb@2ndquadrant.com>
	<62e860f2-ae4b-67a1-b65d-04c3d1bf6aff@2ndquadrant.com>
	<20190918083110.GB22307@paquier.xyz>
	<3f197f5e-9f55-bef3-adc7-2b44c8f8a74f@2ndquadrant.com>
	<20191107041630.GK1768@paquier.xyz>
	<4792e456-d75f-8e6a-2d47-34b8f78c266f@2ndquadrant.com>
	<116725031573825947@iva1-ef4837f8671e.qloud-c.yandex.net>
	<8d8c851a-c951-f98e-22c2-f62621c32d3b@2ndquadrant.com>
	<20191122125603.GA159965@paquier.xyz>
	<CACiyaSqci=MhdEwVZEf=tUOdHfoEZPK9330ajhg5b750nPEenw@mail.gmail.com>

On 2020-01-09 11:57, Alexandra Wang wrote:
> Back to the base backup stuff, I don't quite understand all the benefits you
> mentioned above. It seems to me the greatest benefit with this patch is that
> postmaster takes care of pg_basebackup itself, which reduces the human 
> wait in
> between running the pg_basebackup and pg_ctl/postgres commands. Is that 
> right?
> I personally don't mind the --write-recovery-conf option because it helps me
> write the primary_conninfo and primary_slot_name gucs into
> postgresql.auto.conf, which to me as a developer is easier than editing
> postgres.conf without automation.  Sorry about the dumb question but 
> what's so
> bad about --write-recovery-conf?

Making it easier to automate is one major appeal of my proposal.  The 
current way of setting up a standby is very difficult to automate correctly.

> Are you planning to completely replace
> pg_basebackup with this? Is there any use case that a user just need a
> basebackup but not immediately start the backend process?

I'm not planning to replace or change pg_basebackup.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services





view thread (40+ messages)  latest in thread

Message-ID: <32bfb247-f65c-fb29-e062-f4f8f939d12a@2ndquadrant.com>
Permalink:  ../32bfb247-f65c-fb29-e062-f4f8f939d12a@2ndquadrant.com/
Also on:    postgresql.org/message-id/32bfb247-f65c-fb29-e062-f4f8f939d12a@2ndquadrant.com

 · 

reply
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-hackers@postgresql.org
  Cc: peter.eisentraut@2ndquadrant.com, lewang@pivotal.io, sk@zsrv.org, michael@paquier.xyz
  Subject: Re: base backup client as auxiliary backend process
  In-Reply-To: <32bfb247-f65c-fb29-e062-f4f8f939d12a@2ndquadrant.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