Thread: Slony 1.2 support

Slony 1.2 support

From
Paul Cook
Date:
Hi,

This may be a premature post, since Slony 1.2 is technically only at
RC4, but it should be coming out soon and seems unlikely to change much.

So I tried using pgAdmin III to set up a new Slony replication cluster,
but failed, with details below. Is anyone going to look at the changes
necessary to support Slony 1.2? I'd volunteer, but am new to both Slony
and pgAdmin.

Details:
pgAdmin III 1.4.3 on Windows
PostgreSQL 7.4.7 on Fedora Core 2
Slony 1.2 RC4

The cluster creation script SQL query failed. I traced the problem down
to a missing definition of @MODULEVERSION@, which is defined in the
creation SQL and handled (ie. replaced) correctly by Slony's "slonik"
program, but is not defined in pgAdmin's code -- I believe the correct
place would be src/slony/dlgRepCluster.cpp, function
dlgRepCluster::GetSql(). However, I'm not quite sure what to put there
to maintain compatibility with multiple Slony versions.

The relevant Slony CVS diff is
http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/slony1-
engine/src/slonik/slonik.c.diff?r1=1.60;r2=1.61;cvsroot=slony1;f=h

There may of course be further changes necessary to get full Slony 1.2
support working.

Thanks!
Paul Cook



Re: Slony 1.2 support

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Paul Cook
> Sent: 18 September 2006 19:30
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Slony 1.2 support
>
> Hi,
>
> This may be a premature post, since Slony 1.2 is technically only at
> RC4, but it should be coming out soon and seems unlikely to
> change much.
>
> So I tried using pgAdmin III to set up a new Slony
> replication cluster,
> but failed, with details below. Is anyone going to look at the changes
> necessary to support Slony 1.2? I'd volunteer, but am new to
> both Slony
> and pgAdmin.
>
> Details:
> pgAdmin III 1.4.3 on Windows
> PostgreSQL 7.4.7 on Fedora Core 2
> Slony 1.2 RC4
>
> The cluster creation script SQL query failed. I traced the
> problem down
> to a missing definition of @MODULEVERSION@, which is defined in the
> creation SQL and handled (ie. replaced) correctly by Slony's "slonik"
> program, but is not defined in pgAdmin's code -- I believe the correct
> place would be src/slony/dlgRepCluster.cpp, function
> dlgRepCluster::GetSql(). However, I'm not quite sure what to put there
> to maintain compatibility with multiple Slony versions.
>
> The relevant Slony CVS diff is
> http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/slony1-
> engine/src/slonik/slonik.c.diff?r1=1.60;r2=1.61;cvsroot=slony1;f=h
>
> There may of course be further changes necessary to get full Slony 1.2
> support working.

Thanks Paul - I've committed a fix for this to SVN - it'll be in 1.6
beta 2.

I've also played around with a new cluster and from what I can see, 1.2
is working well with pgAdmin, however if you do  find any bugs, please
forward them on.

Regards Dave.