Re: dbmirror - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: dbmirror
Date
Msg-id 20040513110441.GB24853@phlogiston.dyndns.org
Whole thread Raw
In response to Re: dbmirror  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Responses Re: dbmirror  (Gregory Wood <gwood@ewebengine.com>)
List pgsql-general
On Wed, May 12, 2004 at 05:53:05PM -0700, Gregory S. Williamson wrote:
> Fred --
>
> Yes, the slave database(s) can be safely used in a R/O mode,

Does it also block write transactions in those slaves?  The ability
for clients to write into the slave replicated tables is a problem,
because it makes promoting a slave node somewhat risky.

Slony-I has a trick to solve this problem, BTW.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca

pgsql-general by date:

Previous
From: Patrick Welche
Date:
Subject: Re: referential integrity constraints not checked inside PL/pgSQL functions?
Next
From: Christian Rank
Date:
Subject: Re: referential integrity constraints not checked inside