Hi,
I was trying the process of replicating a postgress DB using Slony. I got stuckup in the process.
1.installed postgres
2.Installed Slony
3.created a DB called "test" and inserted rows.
4.created another DB called "duplicate
5.cluster_setup.sh
#!/bin/sh
slonik <<EOF
cluster name = sql_cluster;
node 1 admin conninfo = 'dbname=test host=localhost user=postgres';
node 2 admin conninfo = 'dbname=duplicate host=localhost user=postgres';
try {
echo ' Initializing the cluster';
init cluster(id = 1, comment = 'Node 1');
}
on error {
echo 'Could not initialize the cluster';
exit -1;
}
create set (id = 1, origin = 1, comment = 'testint');
set add table (set id = 1, origin = 1, id = 1, full qualified name = 'public.test', comment = ' Testing');
set add table (set id = 1, origin = 1, id = 2, full qualified name = 'public.duplicate', comment = ' duplicate Testing');
store node (id = 2, comment = 'Node 2');
store path (server=1, client = 2, conninfo = 'dbname=test host=localhost user=postgres' );
store path (server=2, client = 1, conninfo = 'dbname=duplicate host=localhost user=postgres' );
store listen (origin = 1, provider = 1, receiver = 2);
store listen (origin = 2, provider = 2, receiver = 1);
EOF
6.
[root@ref_deg02 root]$ slon sql_cluster "dbname=test user=postgres" &
[1] 16137
CONFIG main: slon version 1.0.5 starting up
ERROR cannot get sl_local_node_id - ERROR: Namespace "_sql_cluster" does not exist
FATAL main: Node is not initialized properly
[1]+ Exit 255 slon sql_cluster "dbname=test user=postgres"
[root@ref_deg02 root]$
I dont understand what this error means...can anyone explain...what am i doing wrong
Thanks
Priya