473,387 Members | 1,465 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 1839
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Achilleus Mantzios | last post by:
I made a modification on DBMirror.pl, an addition in the slavedatabase.conf file, and added another replication table "specialtables". The goal was to have a way of controlling when a row of...
3
by: Raquel | last post by:
During a ROLLFORWARD recovery, are the log datasets copied from the archive log directory to the active log directory? I know the log datasets are copied from archive log directory to active log...
3
by: jignesh shah | last post by:
Hi all, Is there a way to recover a single container if its been corrupted or mark bad without restoring whole tablespace? environment: db28.1/aix5.1/tsm/rs-6000. Regards Jignesh
2
by: Strahimir Antoljak | last post by:
I am creating a new windows service and I would like to control its Recovery property. On a system administrator level the Recovery property is found in Control Panel -> Administrative Tools ->...
0
by: Fred Fung | last post by:
Hi, Does anybody know if the slave database(s) in the dbmirror replication model can be queried (via SQL SELECT statement) by a client program as if it isquering the master database (I understand...
2
by: Matik | last post by:
Hello, I've follow problem - thing to consider. SQLServer 200 sp3a, ms win 2003 server db simple recovery There is a production database, wich is around 20gb big. Db is backed up each...
8
by: Raj | last post by:
-Is it possible to recover a tablespace just from a full offline backup and offline incremental backup? If not possible -Can we recover tablespace from Full backup , Wednesdays incremental backup...
7
by: James | last post by:
Today my friend ask me a question about setting logsecond to -1. The following sentences were copied from DB2 InforCenter: "By setting logsecond to -1, you will have no limit on the size of the...
1
by: Andrew E | last post by:
I just took over DBA responsibilities for an Oracle 8i database running on Linux. Although I've been working with relational databases for some time, I'm a bit green on Oracle so forgive me. My...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.