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: (view raw or whole thread)
Lists: pgsql-admin

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
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
Subject:	[ADMIN] dbmirror

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.


---------------------------(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


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-2015 The PostgreSQL Global Development Group