Rajeesh wrote:

>---------- Forwarded message ----------
>From: Rajeesh ev <rajishev at gmail.com>
>Date: Jul 13, 2005 12:10 AM
>Subject: help
>To: cbbrowne at gmail.com
>
>
>helo
>
>
>               Am new to this slony and i configured and run slony
>successfully. but the problem is that out projects contain more than
>400 tables .so whether i have to add all the tables manually ? or is
>there any oethr solution for that?
>  
>
Assuming they all have primary keys, I might do something like the
following to generate the slonik:

create sequence tabseq;
select 'set add table (set id=1,origin=1,id=' || nextval('tabseq') || ',
fully qualified name=\'' || table_schema || '.' || table_name || '\',
comment=\'Table ' || table_schema || '.' || table_name || '\');' from
information_schema.tables  where table_type = 'BASE TABLE' and
table_schema not in ('pg_catalog', 'information_schema');

There are tools that can help with this, including slonik_build_env,
found in the tools/altperl directory of the Slony-I 1.1 distribution

I don't recall the URL, but there's something I think called metaslonik
that could help.

>         whats your opinion about pgpool. and i can't configure that
>upto now. my prime concer is for swicth over facility. can you help
>me..
>  
>
One of our guys has been looking at pgpool with a little less success
than we were hoping for.

It is a tool that still needs some work when looking at it from the
"we'd be prepared to spend an extra $1/4M for HACMP" perspective.

Others have been having some satisfactory results with pgpool; you
should probably explore some of the PostgreSQL mailing lists for more on
that.