Twilight wrote:

>Hi to everyone, I'm trying to replicate all the databases my postgres
>has (near 60). Obviously I cant specify for each database its tables
>when creating a set. There's anyway to do what I want or slony-1 is not
>what I need ??
>  
>
I would not expect this to turn out really well...

Why is it that you have 60 databases?  Is this a web hosting scenario
where each user has their own database?

If it is any kind of option to combine these databases together, and
separate the data based on namespaces, I'd expect that to turn out
somewhat better.

You may be able to support it if you HEAVILY automate the management of
schemas, although since each DB would need to be a cluster, and each
cluster needs a slon process per node, you're talking about having at
least 120 slon processes...

In any case, it sounds, based on first impressions, that the PostgreSQL
8.0 Point In Time Recovery system may be more easily suited to this. 
That approach involves copying WAL files from source host to destination
host(s), and will handle as many databases as you might have on the system.

PITR unfortunately doesn't give you the ability to have a "hot" standby
that can be used to support read-only queries...