Szórádi Ervin szoradi at t-email.hu
Sun Apr 29 14:20:50 PDT 2007
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 );


More information about the Slony1-general mailing list