From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Configuring synchronous replication |
Date: | 2010-09-23 21:28:47 |
Message-ID: | 1285277327.17321.1137.camel@ebony |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On Wed, 2010-09-22 at 15:31 -0700, Josh Berkus wrote:
> > The above case is one where I can see your point and it does sound
> > easier in that case. But I then think: "What happens after failover?".
> > We would then need to have 12 different standby.conf files, one on each
> > standby that describes what the setup would look like if that standby
> > became the master. And guess what, every time we made a change on the
> > master, you'd need to re-edit all 12 standby.conf files to reflect the
> > new configuration. So we're still back to having to edit in multiple
> > places, ISTM.
>
> Unless we can make the standby.conf files identical on all servers in
> the group. If we can do that, then conf file management utilities,
> fileshares, or a simple automated rsync could easily take care of things.
Would prefer table.
> But ... any setup which involves each standby being *required* to have a
> different configuration on each standby server, which has to be edited
> separately, is going to be fatally difficult to manage for anyone who
> has more than a couple of standbys. So I'd like to look at what it
> takes to get away from that.
Agreed.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Training and Services
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-09-23 21:47:43 | pgsql: Replace doc references to install-win32 with install-windows. |
Previous Message | Tom Lane | 2010-09-23 21:17:37 | pgsql: ProcessIncomingNotify *must* reset notifyInterruptOccurred when |
From | Date | Subject | |
---|---|---|---|
Next Message | Abhijit Menon-Sen | 2010-09-23 21:31:35 | Re: git cherry-pick timestamping issue |
Previous Message | Joshua D. Drake | 2010-09-23 21:27:34 | Re: git cherry-pick timestamping issue |