Skip site navigation (1) Skip section navigation (2)

Re: dbmirror

From: "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>
To: "Edward Konetzko" <konetzed(at)linuxworkz(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: dbmirror
Date: 2005-03-22 22:49:54
Message-ID: 71E37EF6B7DCC1499CEA0316A256832801D4BFEC@loki.wc.globexplorer.net (view raw or flat)
Thread:
Lists: pgsql-admin
Edward,

We have used it for a simple mirroring of transaction data. It has worked like a champ so far, but the number of tables is low (less than 10) and the transactions tend to be inserts (common), updates (less so) and deletes rarely, none of them very frequent. The two servers are quite close physically (different racks but the same cage), and the speed of updates is reliable. We've only had to roll over from the primary to the mirror a couple of times, and both times the process was painless (going back the other way when the primary is back up is more of a pain, of course, other replicators are far better at that sort of thing; with dbmirror you have to do it manually.

Greg Williamson
DBA
GlobeXplorer LLC

-----Original Message-----
From:	Edward Konetzko [mailto:konetzed(at)linuxworkz(dot)com]
Sent:	Tue 3/22/2005 2:34 PM
To:	pgsql-admin(at)postgresql(dot)org
Cc:	
Subject:	[ADMIN] dbmirror
Hi

I was wondering if anyone is using the dbmirror stuff that come with 
postgres versions >7.3.1.  If so what kind of experiences have you had.  
I am looking a small number < 10 tables that will contain a lot of very 
important data and I would like a way to replicate it.

Thanks
Edward

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
      message can get through to the mailing list cleanly

!DSPAM:42409b5594949384715446!





pgsql-admin by date

Next:From: rootDate: 2005-03-23 03:31:45
Subject: Import Database
Previous:From: Edward KonetzkoDate: 2005-03-22 22:34:21
Subject: dbmirror

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group