Re: Standby registration - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Standby registration
Date
Msg-id 4C9B1F3B.1070205@enterprisedb.com
Whole thread Raw
In response to Re: Standby registration  (Dimitri Fontaine <dfontaine@hi-media.com>)
List pgsql-hackers
On 23/09/10 12:32, Dimitri Fontaine wrote:
> Heikki Linnakangas<heikki.linnakangas@enterprisedb.com>  writes:
>> Hmm, that situation can arise if there's a network glitch which leads the
>> standby to disconnect, but the master still considers the connection as
>> alive. When the standby reconnects, the master will see two simultaneous
>> connections from the same standby. In that scenario, you clearly want to
>> disconnect the old connetion in favor of the new one. Is there a scenario
>> where you'd want to keep the old connection instead and refuse the new
>> one?
>
> Protection against spoofing? If connecting with the right IP is all it takes…

You also need to authenticate with a valid username and password, of 
course. As the patch stands, that needs to be a superuser, but we should 
aim for smarter authorization than that.

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


pgsql-hackers by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: Standby registration
Next
From: Pavel Stehule
Date:
Subject: Re: wip: functions median and percentile