Re: syncronizing databases?

From: "Linn Kubler" <LKubler(at)ecw(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: syncronizing databases?
Date: 2002-07-15 17:09:40
Message-ID: sd32bba4.094@gw1.inet.ecw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks to all who responded to my question. Just to bring closure to
this thread it looks like the easiest approach is to build my own at
this point. So that's what I'll do.

Thanks again,
Linn

>>> "Linn Kubler" <LKubler(at)ecw(dot)org> 07/11/02 11:09AM >>>
Hi All,

If this is the wrong list to post this question to forgive me, correct
me and I'll be out of your hair.

Here's my question:

I have two identical databases setup on separate servers and I'm
looking for ideas on how to keep the data syncronized. I'm wondering
if
there is some feature or function of PostgresQL that will compair
tables
directly or do I need to create my own some how. I'm running
PostgresQL
v7.1 on RedHat 7.2 servers and have a couple of users that will be
maintaining data and need to find a simple method of updating one db
based on the other one. One of our servers is in production, serving
our website, the other is a backup server. I'd like to have the users
only need to enter data once, preferably on the backup server and then
either periodically or on demand have the two servers sync. Make
sense?

Any suggestions are greatly appreciated.

Thanks in advance,
Linn

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

Browse pgsql-general by date

  From Date Subject
Next Message Henrik Steffen 2002-07-15 17:14:01 EMERGENCY
Previous Message ktt 2002-07-15 16:58:43 Re: help (maybe i'm a little stupid)