Andrei,

On Fri, Apr 15, 2005 at 12:14:20PM +0300, Andrei Bintintan wrote:
> 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

You can do this. You'll have to put the tables for your partial replica
in their own set, then fire up the slon for this node long enough for it
to catch up, and then shut it down again.

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

You should look for a postgresql-dev package. It should contain all of
the header files that slony needs to build.


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

You may want to take a look at the documentation in cvs. It's a vast
improvement over the old docs. In particular, check out the admin guide.
It should answer a lot of your questions.

Tim

> 
> 
> 
> Thanks for any help.
> Andy.
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general


-- 
Tim Goodaire    416-673-4126    tgoodair at ca.afilias.info
Database Administrator, Afilias Canada Corp.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://gborg.postgresql.org/pipermail/slony1-general/attachments/20050415/f454672a/attachment.bin