Re: Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Michael Paquier
On Mon, Sep 10, 2018 at 06:12:52PM +0300, Sergei Kornilov wrote: > There were already some discussions about move recovery.conf into GUC > infrastructure first. I continue work on one most recent patch here: > https://commitfest.postgresql.org/19/1711/ If this patch will be > committed - i plan sen

Re: Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Sergei Kornilov
Hello > Is there any reason this cannot be changed via a signal?  Is it a general > lack of infrastructure or is it there significant problem we want to ensure > never happens? Just make possible reload recovery.conf is not what the pgsql-hackers community want. My patch with exactly this featu

Re: Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Chris Travers
On Mon, Sep 10, 2018 at 1:36 PM Michael Paquier wrote: > On Mon, Sep 10, 2018 at 12:08:07PM +0300, Sergei Kornilov wrote: > >> This parameter is defined in postgresql.conf > > Huh, i believe it be in future. > > Currently it is recovery.conf parameter, and yes - it can be set (or > > changed) onl

Re: Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Michael Paquier
On Mon, Sep 10, 2018 at 12:08:07PM +0300, Sergei Kornilov wrote: >> This parameter is defined in postgresql.conf > Huh, i believe it be in future. > Currently it is recovery.conf parameter, and yes - it can be set (or > changed) only at database start. Thanks Sergei for the correction. Indeed yo

Re: Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Sergei Kornilov
Hi > This parameter is defined in postgresql.conf Huh, i believe it be in future. Currently it is recovery.conf parameter, and yes - it can be set (or changed) only at database start. regards, Sergei

Re: Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Michael Paquier
On Mon, Sep 10, 2018 at 04:32:39PM +0800, Jinhua Luo wrote: > If I need to change the master address from which the slave > replicates, must I restart the postgresql? Or just reload is ok? This parameter is defined in postgresql.conf, you need to restart the instance. -- Michael signature.asc De

Can I just reload the slave to change primary_conninfo?

2018-09-10 Thread Jinhua Luo
Hi All, If I need to change the master address from which the slave replicates, must I restart the postgresql? Or just reload is ok?