Re: pgsql: walreceiver uses a temporary replication slot by default

2020-02-14 Thread Kyotaro Horiguchi
At Thu, 13 Feb 2020 16:48:21 +0900, Michael Paquier wrote in > On Wed, Feb 12, 2020 at 06:11:06PM +0900, Fujii Masao wrote: > > On 2020/02/12 7:53, Jehan-Guillaume de Rorthais wrote: > >> In my humble opinion, I prefer the previous behavior, streaming without > >> temporary slot, for one

Re: pgsql: walreceiver uses a temporary replication slot by default

2020-02-12 Thread Michael Paquier
On Wed, Feb 12, 2020 at 06:11:06PM +0900, Fujii Masao wrote: > On 2020/02/12 7:53, Jehan-Guillaume de Rorthais wrote: >> In my humble opinion, I prefer the previous behavior, streaming without >> temporary slot, for one reason: primary availability. > > +1 > >> With temp slot created by default,

Re: pgsql: walreceiver uses a temporary replication slot by default

2020-02-12 Thread Fujii Masao
On 2020/02/12 7:53, Jehan-Guillaume de Rorthais wrote: Hello, On Mon, 10 Feb 2020 16:37:53 +0100 Peter Eisentraut wrote: On 2020-01-23 21:49, Robert Haas wrote: On Tue, Jan 14, 2020 at 8:57 AM Peter Eisentraut wrote: walreceiver uses a temporary replication slot by default If no

Re: pgsql: walreceiver uses a temporary replication slot by default

2020-02-11 Thread Jehan-Guillaume de Rorthais
Hello, On Mon, 10 Feb 2020 16:37:53 +0100 Peter Eisentraut wrote: > On 2020-01-23 21:49, Robert Haas wrote: > > On Tue, Jan 14, 2020 at 8:57 AM Peter Eisentraut > > wrote: > >> walreceiver uses a temporary replication slot by default > >> > >> If no permanent replication slot is configured

Re: pgsql: walreceiver uses a temporary replication slot by default

2020-02-10 Thread Peter Eisentraut
On 2020-01-23 21:49, Robert Haas wrote: On Tue, Jan 14, 2020 at 8:57 AM Peter Eisentraut wrote: walreceiver uses a temporary replication slot by default If no permanent replication slot is configured using primary_slot_name, the walreceiver now creates and uses a temporary replication slot.

Re: pgsql: walreceiver uses a temporary replication slot by default

2020-01-23 Thread Robert Haas
On Tue, Jan 14, 2020 at 8:57 AM Peter Eisentraut wrote: > walreceiver uses a temporary replication slot by default > > If no permanent replication slot is configured using > primary_slot_name, the walreceiver now creates and uses a temporary > replication slot. A new setting

pgsql: walreceiver uses a temporary replication slot by default

2020-01-14 Thread Peter Eisentraut
walreceiver uses a temporary replication slot by default If no permanent replication slot is configured using primary_slot_name, the walreceiver now creates and uses a temporary replication slot. A new setting wal_receiver_create_temp_slot can be used to disable this behavior, for example, if