470,614 Members | 1,434 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

dbmirror -- recovery question

Dear peoples,

I'm setting up a database in postgres which will have light traffic writing to a few tables (and somewhat heavier traffic reading 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 master and then manually reconcile the former master when it is available, perhaps ?

I didn't see anything in the documentation or in the postgres site about this (and I looked through the archives for references to dbmirror), so I apologize if I am issuing a faq.

Thanks,

Greg Williamson
DBA
GlobeXplorer LLC

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 11 '05 #1
1 1784
In article <71**************************************@loki.glo bexplorer.com>,
"Gregory S. Williamson" wrote:
I'm setting up a database in postgres which will have light traffic
writing to a few tables (and somewhat heavier traffic reading 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 master and then manually reconcile
the former master when it is available, perhaps ?

I didn't see anything in the documentation or in the postgres site about
this (and I looked through the archives for references to dbmirror), so I
apologize if I am issuing a faq.


While, this might not solve your problem (and dbmirror might have
solution of it's own for this) I would like to point out utility that
I'm working on right now called pgdiff. Since, it's so fresh I still
consider it somewhat experimental. Basically, it allows you to make
a diff of two databases on different hosts and spits out inserts,
selects and updates to sync databases.

Right now it's not clever enough to skip serial colums (or any other
with sequence attached to it), but as I said, I'm working on it (I'm
using it for regression tests on rserv, so it has to be accurate).

http://www.rot13.org/~dpavlin/sql.html

I must warn you that current version is one big perl script, and next
one will use Pg::Scheme module (which is actually a fork of this
command) so you'll have to download more than one file.

--
Dobrica Pavlinusic 2share!2flame dp*****@rot13.org
Unix addict. Internet consultant. http://www.rot13.org/~dpavlin
Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Achilleus Mantzios | last post: by
3 posts views Thread by jignesh shah | last post: by
2 posts views Thread by Strahimir Antoljak | last post: by
reply views Thread by Fred Fung | last post: by
1 post views Thread by Andrew E | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.