Re: Slony 1.2 support

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Paul Cook" <pcook(at)caltech(dot)edu>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Slony 1.2 support
Date: 2006-09-19 10:17:51
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E40154CDAF@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Paul Cook
> Sent: 18 September 2006 19:30
> To: pgadmin-support(at)postgresql(dot)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.

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-09-19 10:23:50 Re: pgAgent Job never starts
Previous Message Vincent CORDIER - LOGIXEN 2006-09-19 09:12:42 pgAgent Job never starts