"Garry Saddington" <garry at schoolteachers.co.uk> writes:
> Hello, I am new to this list and to Slony so excuse me if I ask
> simple questions. I was wondering if there is a way to specify an
> entire database to replicate rather than having to list each table
> specifically.

No, not as such.

You could run queries on information_schema.tables, looking for
entries where table_type is 'BASE TABLE'.  You would also presumably
want to replicate a subset of the sequences, too.

There is a script in the tools directory that will draw out this sort
of information.  Look for "build_env.pl".

What I find is that in systems that warrant replication, there will be
tables that oughtn't be replicated so that blindly replicating
everything turns out badly.  If it "warrants replication," there will
be some complexity to what is going on, and, very likely, temporary
"cruft" will head in as "messy situations" arise.  (If handled well,
the "messes" ought to be confined to their own namespaces/schemas so
that, once resolved, they can be dropped out cleanly...)
-- 
let name="cbbrowne" and tld="ca.afilias.info" in name ^ "@" ^ tld;;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)