From: Steve Crawford <scrawford@pinpointresearch.com>
To: shadow@s3os.net
To: pgsql-admin@postgresql.org
Subject: Re: Database syncronization
Date: Wed, 20 Apr 2005 10:00:57 -0700
Message-ID: <200504201000.57192.scrawford@pinpointresearch.com> (raw)
In-Reply-To: <200504201844.27060.shadow@s3os.net>
References: <200504201844.27060.shadow@s3os.net>
On Wednesday 20 April 2005 9:44 am, Shadow wrote:
> Hy all !
>
> Is there any tool, middelware, or feature to syncronize 2 databases
> (With the same schema, ofcourse)
>
> I have an application that runs from 2 points. One of this points
> has a master database and the other point neds to sync its data
> daily from the master.
There are several options depending on your needs.
If you just need a second machine updated daily then just do a
pg_dumpall from the master and restore it on the second machine (all
automated from cron).
Alternately, in 8.x you can copy the master's files to the second
machine and then just use the WAL files to keep the second machine
up-to-date. If you like this option check the backup section of the
documentation, especially section 22.3, to read about on-line backup
and recovery.
For near real-time replication you can use a replication solution like
slony-i.
All of the above assume that all modifications to the database are
done to the master and simply duplicated one way or another to a
slave.
There are also projects that act as connection-pooling and
load-balancing solutions that write all changes to multiple
databases. I believe dbbalancer is one but it is listed as "Alpha"
and the last update was in 2002.
Cheers,
Steve
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, shadow@s3os.net
Subject: Re: Database syncronization
In-Reply-To: <200504201000.57192.scrawford@pinpointresearch.com>
References: <200504201844.27060.shadow@s3os.net> <200504201000.57192.scrawford@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox