On Thu, Nov 24, 2005 at 12:24:05AM -0600, Jim Kunkel wrote:
> We have a couple of dozen postgresql / apache servers running on
> LAN's for a client.  These are scattered around the country.
> Presently, we pg_dump the databases once a day and rsync the files
> to a central backup.
> 
> I would like to provide a read-only copy of the databases on a
> central server, so individual site data could be queried and
> analyzed centrally, but not changed and pushed back out.
> 
> The overview documentation indicates that Slony is intended to be a
> single master to multiple slaves.  Can multiple masters replicate to
> many separate slave databases running on a single server?

Sure.  This sounds like a large bunch of two-node clusters whose
subscriber nodes all happen to be on one bit of hardware.

Cheers,
D
-- 
David Fetter david at fetter.org http://fetter.org/
phone: +1 415 235 3778

Remember to vote!