Re: PostgreSQL Replication with read-only access to standby DB

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Replication with read-only access to standby DB
Date: 2008-03-26 13:53:51
Message-ID: 20080326135351.GB5372@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, Mar 26, 2008 at 01:03:34AM -0400, Greg Smith wrote:

> against. People who are using the current warm-standby code are already
> grappling with issues like how to coordinate master/slave failover
> (including my second favorite acronym, STONITH for "shoot the other node
> in the head"). I don't expect handling that sort of thing will ever be
> integrated into the PostgreSQL database core.

Note that most other database products don't integrate it in their core
either. They package separate tools for it, and sell it as a single system,
but you can often buy the separate tools independently. Oracle's RAC is an
exception, but it also works completely differently than any of this.

A

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin 2008-03-26 14:08:37 Re: Make MS Access "UPDATE" PostGre SQL Table
Previous Message Alvaro Herrera 2008-03-26 13:21:17 Re: Reindex does not finish 8.2.6

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-26 13:54:46 Re: Auto Partitioning Patch - WIP version 1
Previous Message Bruce Momjian 2008-03-26 13:48:40 Re: Auto Partitioning Patch - WIP version 1