Re: Sync Rep Design - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Sync Rep Design
Date
Msg-id AANLkTikfZWhxMgQc9uVbqnVAcyUMZtwwH99GoSW92L4a@mail.gmail.com
Whole thread Raw
In response to Re: Sync Rep Design  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Sync Rep Design  (Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>)
List pgsql-hackers
On Fri, Dec 31, 2010 at 7:57 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> On 31.12.2010 14:40, Robert Haas wrote:
>>
>> Someone may have proposed this before, but one way of getting standby
>> naming "for free" would be to make the standby names the same as the
>> roles used to log in, rather than adding a separate parameter.  We
>> could just recommend to people that they use a separate, descriptive
>> role name for each standby.  Then the synchronous_standbys parameter -
>> when added - would mean "a standby from one of these roles".
>
> Seems a bit weird. It's not a lot of effort to give each standby a name. But
> if you want something automatic, how about gethostname() ?

Uh, wow, no way.  That would be making a critical aspect of system
reliability depend on something way, way outside of our configuration.

What's weird about using the role name?  That's our standard way of
distinguishing between two or more users.  Why invent something new?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: and it's not a bunny rabbit, either
Next
From: Peter Eisentraut
Date:
Subject: Re: and it's not a bunny rabbit, either