The scenario is the following:
I have a main database on a server probably this will be the master.
With this replication we want first to make a copy of this database which
will be at another location(another company) with 1 time/day sincronization,
so this will be a slave which will contain a part of the database(so not all
the tables) ~ asyncronus replication
and
we also would like to make a backup server in our local LAN which will
contain a complete backup of the main database in case of the server fail.
We would like a free solution if possible,
I read about Slony, what about erserver? http://www.pgsql.com/download/ or
http://gborg.postgresql.org/project/erserver/projdisplay.php
Did anyone used it? Which is better to use?
Thanks for any tipps.
Andy.
----- Original Message -----
From: "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx>
To: "John DeSoi" <desoi@xxxxxxxxxx>
Cc: "Andrei Bintintan" <klodoma@xxxxxxxxx>; <pgsql-admin@xxxxxxxxxxxxxx>
Sent: Tuesday, April 12, 2005 7:39 PM
Subject: Re: [ADMIN] PostgreSQL replication solution?
John DeSoi wrote:
On Apr 12, 2005, at 2:48 AM, Andrei Bintintan wrote:
I have to do a database replication (of corse pgsql database) and I
never done something like this. I still read about ... what replication
is.
Can anyone send me some directions, documentation, ideeas, solutions?
Here is a nice article on Slony:
http://www.onlamp.com/pub/a/onlamp/2004/11/18/slony.html
You can also look at replicator over at http://www.commandprompt.com/ . It
is simpler to setup than slony but it is not free.
Sincerely,
Joshua D. Drake
