Re: Parameter name standby_mode - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Parameter name standby_mode
Date
Msg-id 4B74FD64.8000909@enterprisedb.com
Whole thread Raw
In response to Re: Parameter name standby_mode  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: Parameter name standby_mode
List pgsql-hackers
Fujii Masao wrote:
> On Fri, Feb 12, 2010 at 3:19 PM, Heikki Linnakangas
> <heikki.linnakangas@enterprisedb.com> wrote:
>> Fujii Masao wrote:
>>> But if we fail in restoring the archived WAL file, "standby_mode = on"
>>> *always* tries to start streaming replication.
>> Hmm, somehow I thought it doesn't if you don't set primary_conninfo. I
>> think that's the way it should work, ie. if primary_conninfo is not set,
>> don't launch walreceiver but just keep trying to restore from the archive.
> 
> Yeah, even if primary_conninfo is not given, the standby tries to invoke
> walreceiver by using the another connection settings (environment variables
> or defaults). This is intentional behavior, and would make the setup of SR
> easier. So I'd like to leave it be.

You could do primary_conninfo='' for that.

Maybe we should have two options, "streaming_mode='on'" and
"primary_conninfo='...'".

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Joachim Wieland
Date:
Subject: Re: Parameter name standby_mode
Next
From: Andrew McNamara
Date:
Subject: Re: Confusion over Python drivers