First... this is my first attempt to replication. Have no ideea how to make it. Some of my problems probably will be stupid :(

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. 
It seems ok but facing problems: first I use Suse Linux 9.1, I installed Postgresql 8.01 from rpm's and when I try to install Slony it ask for sources. I didn't find the src's in the rpm, but I downloaded the src's from postgresql site. Still Slony asks me to configure and install those sources first and then try to install Slony. Do I have to install manually postgre to use Slony? I would be happy to leave the rpm installation running...

Although the documentation is a little "heavy" for me to understand, does anyone know tipps and tricks?



Thanks for any help.
Andy.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050415/7464b5e3/attachment-0001.html