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:[EMAIL PROTECTED] Sent: Tue 3/22/2005 2:34 PM To: pgsql-admin@postgresql.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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly !DSPAM:42409b5594949384715446! ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
