Sun Apr 29 14:20:50 PDT 2007
- Previous message: [Slony1-general] Slony on Windows
- Next message: [Slony1-general] Slony on Windows
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi. Yes, I did. I tried the slonik in cmd. It's worked. I could create cluster. The cluster name is replica. I used small letters only. I think it isn't work. Please see the picture and an attached files. Regards, Ervin Szoradi Hiroshi Saito =EDrta: > Hi. > > It is strange... I think there is a proposal to divide the problem. > Did you operate all with pgAdmin3 without using slonik? > Please operate it with slonik again if it is so. I saw the screen > and a related problem of the capital letter and the small > letter was anxious. However, I think that there is BUG somewhere. > It is slonik and if it is certain, it might be a problem of pgAdmin3. > Anyway, Could you confirm it? > If it is possible, please send me those scripts again. > > Thanks! > > Regards, > Hiroshi Saito > > ----- Original Message ----- From: Sz=F3r=E1di Ervin > Cc: slony1-general at lists.slony.info > Sent: Monday, April 23, 2007 1:36 AM > Subject: Re: [Slony1-general] Slony on Windows > > > Hi. > > Thank You for your advice. > It was useful but I could only one create a cluster. > I don't know how! > > I have got 2 PC. > The system is WinXp + PostgreSql 8.1 + Slony 1.2.9. on computers. > Those computers database is same. > I created it by template / creator script. > > I made the following steps on two Pc: > > 1. -regservice pc1 / pc 2 It`s OK. > 2. addengines PC 1 C:\slony\master.conf (slon Cluster = > "dbname=3DTimarvasker host=3Dlocalhost user=3Dpostgres") It`s OK. > PC 2 C:\slony\slave.conf (slon Cluster = > "dbname=3DTimarvasker host=3Dlocalhost user=3Dpostgres") It`s OK. > 3. Create on Pc 1 Cluster (1 Master ;99 PgAdminNode) It`s OK. > 4. I try join existing cluster on Pc 2 and a receive the following = > message: > > > > Why??? > > Please help Me!! > > The Japan is difficult. > Please rewrite it. > > Regards, > > Ervin Szoradi > > Hiroshi Saito =EDrta: > Hi. > > It is written here. However, it was not detailed yet. > http://main.slony.info/documentation/installation.html > > I have written the document of the usage in windows for Japan, > http://www.gihyo.co.jp/book/2006/232351/download/Slony-I.zip > It is scheduled to be rewritten in English. However, I'm late for the > reasons of very busy now..... > > Moreover, the usage is written in detail here. > http://www.pgadmin.org/docs/1.6/slony.html > > Regards, > Hiroshi Saito > > ----- Original Message ----- From: "Sz=F3r=E1di Ervin" <szoradi at t-email.h= u> > To: <slony1-general at lists.slony.info> > Sent: Friday, April 20, 2007 3:48 AM > Subject: [Slony1-general] Slony on Windows > > > > Hello. > > My name is Ervin Szoradi. > > I would like to use Slony-I but I don't know how can I configure it. > > My system is WinXp + PostgreSql 8.1 + Slony 1.2.9. > > Please write short example. > > Please help me! > > Thanks. > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > > > > > > > > > > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > -------------- next part -------------- slon replica "dbname=3DTimarvasker host=3Dlocalhost user=3Dpostgres" -------------- next part -------------- CLUSTER NAME =3D replica; NODE 1 ADMIN CONNINFO =3D 'dbname=3DTimarvasker host=3D192.168.0.15 user=3D= postgres'; NODE 2 ADMIN CONNINFO =3D 'dbname=3DTimarvasker host=3D192.168.0.12 user=3D= postgres'; SUBSCRIBE SET ( ID=3D1, PROVIDER=3D1, RECEIVER=3D2, FORWARD=3DNO ); -------------- next part -------------- slon replica "dbname=3DTimarvasker host=3Dlocalhost user=3Dpostgres" -------------- next part -------------- CLUSTER NAME =3D replica; NODE 1 ADMIN CONNINFO =3D 'dbname=3DTimarvasker host=3D192.168.0.15 user=3D= postgres'; NODE 2 ADMIN CONNINFO =3D 'dbname=3DTimarvasker host=3D192.168.0.12 user=3D= postgres'; INIT CLUSTER ( ID=3D1, COMMENT =3D 'Master Database' ); CREATE SET ( ID=3D1, ORIGIN=3D1, COMMENT=3D'Replication' ); SET ADD TABLE (SET ID=3D1, ORIGIN=3D1, ID=3D1, FULLY QUALIFIED NAME=3D'publ= ic.acc_trans', COMMENT=3D'acc_trans'); SET ADD TABLE (SET ID=3D1, ORIGIN=3D1, ID=3D2, FULLY QUALIFIED NAME=3D'publ= ic.ap', COMMENT=3D'ap'); SET ADD SEQUENCE (SET ID=3D1, ORIGIN=3D1, ID=3D3, FULLY QUALIFIED NAME=3D'p= ublic.id', COMMENT=3D'id'); STORE NODE ( ID=3D2, COMMENT =3D 'Slave Database'); STORE PATH ( SERVER=3D1, CLIENT=3D2, CONNINFO =3D 'dbname=3DTimarvasker hos= t=3D192.168.0.15 user=3Dpostgres'); STORE PATH ( SERVER=3D2, CLIENT=3D1, CONNINFO =3D 'dbname=3DTimarvasker hos= t=3D192.168.0.12 user=3Dpostgres'); STORE LISTEN ( ORIGIN=3D1, PROVIDER=3D1, RECEIVER=3D2 ); STORE LISTEN ( ORIGIN=3D2, PROVIDER=3D2, RECEIVER=3D1 );
- Previous message: [Slony1-general] Slony on Windows
- Next message: [Slony1-general] Slony on Windows
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list