Thanks for your repaly
I have done with that but facing the same problem.
Actually what i want to do is to add a table to a
already existing replication set.
firstly, I will have to create new set
secondly subscrib it .
and finaly merge it.
do i need to create this set in the same cluster into
which i will merge it later on.
If yes, how to do it coz with the slonik script it
gives me error cluster already exists.
Please help.
Thanks
--- Devrim GUNDUZ <devrim@CommandPrompt.com> wrote:
> Hi,
>
> On Thu, 2006-11-30 at 00:12 -0800, Ashish Karalkar
> wrote:
>
> > create set (id=2, origin=1, comment='All tables');
> >
> > but it gives error
> >
> > syntax error near unexpected token `('
>
> That command must be passed to slonik, not to bash.
>
> Here is an example:
>
> #!/bin/bash
> slonik << _END_
>
> cluster name = testcluster;
> node 1 admin conninfo = 'dbname=test1
> host=192.168.2.3 port=5432
> user=postgres';
> node 2 admin conninfo = 'dbname=test2
> host=192.168.2.4 port=5432
> user=postgres';
>
> create set (id=1, origin=1, comment='test tables');
> echo 'Set created';
>
> set add table (set id=1, origin=1, id=1, full
> qualified name =
> 'public.test_table', comment='test table');
> _END_
>
>
> Regards,
> --
> The PostgreSQL Company - Command Prompt, Inc.
> 1.503.667.4564
> PostgreSQL Replication, Consulting, Custom
> Development, 24x7 support
> Managed Services, Shared and Dedicated Hosting
> Co-Authors: plPHP, plPerlNG -
> http://www.commandprompt.com/
>
>
>
>
>
____________________________________________________________________________________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
