Re: Don'st start streaming after creating a slot in pg_receivexlog - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Don'st start streaming after creating a slot in pg_receivexlog
Date
Msg-id CANP8+jKWrRv-aA4Hc+yr04rD2W+One-yW7cDPvrG=gpBU6o_gw@mail.gmail.com
Whole thread Raw
In response to Don'st start streaming after creating a slot in pg_receivexlog  (Andres Freund <andres@anarazel.de>)
Responses Re: Don'st start streaming after creating a slot in pg_receivexlog
List pgsql-hackers
On 29 July 2015 at 08:37, Andres Freund <andres@anarazel.de> wrote:
 
Heikki complained about pg_receivexlog --create-slot starting to stream
in his talk in St. Petersburg. Saying that that makes it a hard to
script feature - and I have to agree. Since that option is new to 9.5 we
can should change that behaviour now if we decide to.

Michael, what do you think?

--drop-slot seems pointless, since you can just do that with psql

If we make --create-slot do nothing but add the slot, then that seems pointless also

Would we need to add those options to all commands, when it can be done with psql?

I'd suggest just removing --create-slot and --drop-slot altogether

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

pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Don'st start streaming after creating a slot in pg_receivexlog
Next
From: Simon Riggs
Date:
Subject: Re: pg_basebackup and replication slots