Re: Transaction-controlled robustness for replication

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Transaction-controlled robustness for replication
Date: 2008-08-13 16:46:18
Message-ID: 1218645978.5343.390.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Wed, 2008-08-13 at 11:27 -0400, Bruce Momjian wrote:

> I disagree. If they make it the master they change the setting.

It's not acceptable to force people to edit a configuration file when
failover occurs. Some people wish to automate this and fumbling
parameter values at this important time is definitely inappropriate. We
gain nothing by asking people do do things that way.

Plus, as I have said: if it is controlled on the Standby then it will
not be transaction-controlled and this will be a useful thing.

I asked myself "where would I like to be set?" The answer was "on the
master". If you think differently, please say why. Yes, we can set it on
the standby, but I see no reason to do so.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Decibel! 2008-08-13 16:49:10 Re: SeqScan costs
Previous Message Tim Hawes 2008-08-13 16:35:36 Re: C Extension woes