All,

I've been searching for Slony documentation for several days, and I've
found some great documentation out there. However, there is one bit that
I seem to be missing. Let me explain my environment first:

Linux server running Postgres 8.1.11 with 20 databases running under a
single postmaster instance. We just built a new backup server that we
would like to replicate everything to (and keep the replication running
at all times) to ensure data integrity in case of hardware failure.

All of the documentation that I've found is for replicating a single
database to another postmaster instance (locally or remotely). I have
been unable to find anything that allows me to extrapolate how to do 20
databases from a postmaster to 20 databases on another postmaster.

If anyone has any pointers on the best way to do this, I would
appreciate it.

Also, from my reading, I have been lead to believe that a single instance
of 'slon' will be running for each database/node. Is this correct? Does
this mean that I'll have 20 instances of slon running on each server? If
this is the case, is the memory footprint of the process known? I can
find out on my own, but if someone knows off the top of the head, I'd
appreciate the information.

Thanks!

-- 
John Evans
Administrator of kilnar.com