From: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: Josh Berkus <josh@postgresql.org>
Cc: Hannu Krosing <hannu@2ndquadrant.com>
Cc: pgsql-hackers@postgresql.org
Subject: Re: Sync Rep Design
Date: Fri, 31 Dec 2010 14:48:41 +0100
Message-ID: <4D1DDF39.1030307@kaltenbrunner.cc> (raw)
In-Reply-To: <AANLkTikfZWhxMgQc9uVbqnVAcyUMZtwwH99GoSW92L4a@mail.gmail.com>
References: <1293729972.1892.23804.camel@ebony>
<4D1CC47E.7050207@kaltenbrunner.cc>
<1293735853.1892.24886.camel@ebony>
<AANLkTi=SvN2KQ1Tzh-tRKcXD0i2FyWFBbbR=kXXdepqN@mail.gmail.com>
<4D1D8B2F.5070001@2ndquadrant.com>
<4D1DAB14.5000800@enterprisedb.com>
<1293796137.1892.37313.camel@ebony>
<AANLkTi=48kYeJrWdHoWS65QDjvJwz-yCwau5NwAFmAWp@mail.gmail.com>
<4D1DD33A.8030404@enterprisedb.com>
<AANLkTikfZWhxMgQc9uVbqnVAcyUMZtwwH99GoSW92L4a@mail.gmail.com>
On 12/31/2010 02:39 PM, Robert Haas wrote:
> 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.
+1
>
> What's weird about using the role name? That's our standard way of
> distinguishing between two or more users. Why invent something new?
wel a user is not a host/server for me - given there is no real benefit
from using distinct roles for each standby yet I don't see why we should
complicate the replication setup procedure by requiring 1 role per standby.
So I'm all for giving each standby a name but please make it an explicit
one and not something that is only vaguely related to the actual standby
host.
Stefan
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: stefan@kaltenbrunner.cc, robertmhaas@gmail.com, heikki.linnakangas@enterprisedb.com, simon@2ndquadrant.com, greg@2ndquadrant.com, josh@postgresql.org, hannu@2ndquadrant.com
Subject: Re: Sync Rep Design
In-Reply-To: <4D1DDF39.1030307@kaltenbrunner.cc>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox