Re: failover vs. read only queries - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: failover vs. read only queries
Date
Msg-id 4C11174B.8030606@agliodbs.com
Whole thread Raw
In response to Re: failover vs. read only queries  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Responses Re: failover vs. read only queries
List pgsql-hackers
On 06/09/2010 07:36 PM, Mark Kirkwood wrote:
> On 10/06/10 14:07, Tatsuo Ishii wrote:
>>
>> The one of top 3 questions I got
>> when we propose them our HA solution is, "how long will it take to
>> do failover when the master DB crashes?"
>>
>
> Same here +1

In that case, wouldn't they set max_standby_delay to 0?  In which case 
the failover problem goes away, no?

--                                   -- Josh Berkus                                     PostgreSQL Experts Inc.
                           http://www.pgexperts.com
 


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: 'create or replace function' no longer allows parameters
Next
From: Greg Stark
Date:
Subject: Re: warning message in standby