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 t=
ool
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 wind=
ows have to be declared somewhere in a postgre configuration file ?

------------ cluster-setup.sh --------
#!/bin/sh
CLUSTER=3Dclustertest
DB1=3Dslony-client1
DB2=3Dslony-client2
H=3Dlocalhost
U=3Dpostgres
slonik <<_EOF_
cluster name =3D $CLUSTER;
node 1 admin conninfo =3D 'dbname=3D$DB1 host=3D$H user=3D$U';
node 2 admin conninfo =3D 'dbname=3D$DB2 host=3D$H user=3D$U';
init cluster (id =3D 1, comment =3D 'Node 1');
create set (id =3D 1, origin =3D 1,comment =3D 'contact table');
set add table (set id =3D 1, origin =3D 1, id =3D 1,full qualified name =3D=
 'public.contact',comment =3D 'Table contact');
set add sequence (set id =3D 1, origin =3D 1, id =3D 2,full qualified name =
=3D 'public.contact_id_seq',comment =3D 'Sequence contact_id_seq');
store node (id =3D 2, comment =3D 'Node 2');
store path (server =3D 1, client =3D 2,conninfo =3D 'dbname=3D$DB1 host=3D$=
H user=3D$U');
store path (server =3D 2, client =3D 1,conninfo =3D 'dbname=3D$DB2 host=3D$=
H user=3D$U');
store listen (origin =3D 1, receiver =3D 2);
store listen (origin =3D 2, receiver =3D 1);
subscribe set (id =3D 1, provider =3D 1, receiver =3D 2, forward =3D yes);

------------- launch.sh ---------

#!/bin/sh
CLUSTER=3Dclustertest
DB1=3Dslony-client1
DB2=3Dslony-client2
H=3Dlocalhost
U=3Dpostgres
slon $CLUSTER "dbname=3D$DB1 user=3D$U host=3D$H"
slon $CLUSTER "dbname=3D$DB2 user=3D$U host=3D$H"

-------------- contact table ----------

CREATE TABLE contact
(
  id bigserial NOT NULL,
  "name" character varying(200),
  CONSTRAINT pk_user PRIMARY KEY (id)
)
WITH (OIDS=3DFALSE);
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--

 		 	   		  =

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20091014/=
8226dc1b/attachment.htm