dbmirror and failure/recovery modes - Mailing list pgsql-admin

From Gregory S. Williamson
Subject dbmirror and failure/recovery modes
Date
Msg-id 71E37EF6B7DCC1499CEA0316A25683280105702A@loki.globexplorer.com
Whole thread Raw
List pgsql-admin
Dear peoples,

I'm setting up a database in postgres which will have light traffic writing to a few tables (and somewhat heavier
trafficreading them). We'd like to mirror that databse using dbmirror to two others. 

Let's assume that we're humming along and the master goes down. We switch traffic to read from one of the two slaves.

What happens if we feel a need to add information while the master is down ?  Reconfigure that former slave to be a
masterand then manually reconcile the former master when it is available, perhaps ? 

I didn't see anything in the documentation or in the postgres site, so I apologize if I am issuing a faq.

Thanks,

Greg Williamson
DBA
GlobeXplorer LLC

pgsql-admin by date:

Previous
From: Rafal Kedziorski
Date:
Subject: RE : Oracle to PostgreSQL
Next
From: "Randolph Jones"
Date:
Subject: readline missing on linux?