Thread: PostgreSQL replication solution?
Hi to all,
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?
Thanks.
Andy.
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 John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL
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
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@commandprompt.com> To: "John DeSoi" <desoi@pgedit.com> Cc: "Andrei Bintintan" <klodoma@ar-sd.net>; <pgsql-admin@postgresql.org> 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 > > > > > >