Thu Aug 4 07:50:50 PDT 2005
- Previous message: [Slony1-general] Safe to delete from pg_namespace?
- Next message: [Slony1-general] Problem with Database Replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I created 2 databases (master & slave) and use the following setup script: ================================================== #!/bin/sh CLUSTER=sql_cluster DB1=contactdb DB2=contactdb_slave H1=localhost H2=localhost U=postgres slonik <<_EOF_ cluster name = $CLUSTER; node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U'; node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U'; init cluster (id = 1, comment = 'Node 1'); create set (id = 1, origin = 1, comment = 'contact table'); set add table (set id = 1, origin = 1, id = 1, full qualified name = 'public.contact', comment = 'Table contact'); set add sequence (set id = 1, origin = 1, id = 2, full qualified name = 'public.contact_seq', comment = 'Sequence contact_seq'); store node (id = 2, comment = 'Node 2'); store path (server = 1, client = 2, conninfo = 'dbname=$DB1 host=$H1 user=$U'); store path (server = 2, client = 1, conninfo = 'dbname=$DB2 host=$H2 user=$U'); store listen (origin = 1, provider = 1, receiver = 2); store listen (origin = 2, provider = 2, receiver = 1); ================================================== Then I tried to run a subscribe script below: ================================================== #!/bin/sh CLUSTER=sql_cluster DB1=contactdb DB2=contactdb_slave H1=localhost H2=localhost U=postgres slonik <<_EOF_ cluster name = $CLUSTER; node 1 admin conninfo = 'dbname=$DB1 host=$H1 user=$U'; node 2 admin conninfo = 'dbname=$DB2 host=$H2 user=$U'; subscribe set (id = 1, provider = 1, receiver = 2, forward = yes); ================================================== I got the following error message: ================================================== <stdin>:4: Error: namespace "_sql_cluster" already exists in database of node 1 -bash-3.00$ ./cluster_setup.sh -bash-3.00$ ./subscribe.sh <stdin>:4: NOTICE: subscribeSet:: set 1 has no tables - risk of problems - see bug 1226 <stdin>:4: NOTICE: http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?1226 ================================================== The weird thing is, the database is NOT empty. The table "contact" is there, so the error message doesn't make sense. Please help. Thanks.
- Previous message: [Slony1-general] Safe to delete from pg_namespace?
- Next message: [Slony1-general] Problem with Database Replication
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list