Hi,
I'm a newbee in slony replication. I'm trying to install a client1-client2
replication test on windows vista (sorry...) and Postgres 8.3
First I create the Slony-I windows service. It appears in the service list.
Then I start it.
Then I launch the cluster creation (cluster-setup.sh script) with Cygwin tool
Finaly I launch the slon deamons with launch.sh
Resulting the launch.sh I got the following 6 lines :
>>> CONFIG main: slon version 1.2.15 starting up
>>> ERROR cannot get sl_local_no_id - Error: schema "_clustertest" does not
>>> exist
>>> FATAL main: Node is not initialized properly - sleep 10s
>>> CONFIG main: slon version 1.2.15 starting up
>>> ERROR cannot get sl_local_no_id - Error: schema "_clustertest" does not
>>> exist
>>> FATAL main: Node is not initialized properly - sleep 10s
Fact : I can see _clustertest schema in both database.
Questions :
- one of my script is wrong ?
- did i miss on step on windows postgresql configuration ?
- the pgpass.conf file ( stored at ..../postresql/8.3/pgpass.conf ) on windows
have to be declared somewhere in a postgre configuration file ?
------------ cluster-setup.sh --------
#!/bin/sh
CLUSTER=clustertest
DB1=slony-client1
DB2=slony-client2
H=localhost
U=postgres
slonik <<_EOF_
cluster name = $CLUSTER;
node 1 admin conninfo = 'dbname=$DB1 host=$H user=$U';
node 2 admin conninfo = 'dbname=$DB2 host=$H 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_id_seq',comment = 'Sequence contact_id_seq');
store node (id = 2, comment = 'Node 2');
store path (server = 1, client = 2,conninfo = 'dbname=$DB1 host=$H user=$U');
store path (server = 2, client = 1,conninfo = 'dbname=$DB2 host=$H user=$U');
store listen (origin = 1, receiver = 2);
store listen (origin = 2, receiver = 1);
subscribe set (id = 1, provider = 1, receiver = 2, forward = yes);
------------- launch.sh ---------
#!/bin/sh
CLUSTER=clustertest
DB1=slony-client1
DB2=slony-client2
H=localhost
U=postgres
slon $CLUSTER "dbname=$DB1 user=$U host=$H"
slon $CLUSTER "dbname=$DB2 user=$U host=$H"
-------------- contact table ----------
CREATE TABLE contact
(
id bigserial NOT NULL,
"name" character varying(200),
CONSTRAINT pk_user PRIMARY KEY (id)
)
WITH (OIDS=FALSE);
ALTER TABLE contact OWNER TO postgres;
-------------- pgpass.conf ---------------
127.0.0.1:5432:slony-client1:postgres:--secret--
127.0.0.1:5432:slony-client2:postgres:--secret--
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
