| Christopher Browne 2005-07-13, 11:24 am |
| Rajeesh wrote:
>---------- Forwarded message ----------
>From: Rajeesh ev <rajishev- Re5JQEeQqe8AvxtiuMwx
3w@public.gmane.org>
>Date: Jul 13, 2005 12:10 AM
>Subject: help
>To: cbbrowne- Re5JQEeQqe8AvxtiuMwx
3w@public.gmane.org
>
>
>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.
|