Re: Problem using Slony-I with pgadmin 1.6.2

> ------- Original Message -------
> From: Kandy Wong <kandyw(at)triumf(dot)ca>
> To: Dave Page <dpage(at)postgresql(dot)org>
> Sent: 15/12/07, 00:56:46
> Subject: Re: [pgadmin-support] Problem using Slony-I with pgadmin 1.6.2
>
> Dave Page wrote:
> > Kandy Wong wrote:
> >
> >> SL4 is Scientific Linux 4 and it's like CentOS 4 which is a compatible
> >> rebuild of the Red Hat Enterprise Linux 4. The F7 RPM doen't work for me.
> >> So when I tried to add a New Slony-I Cluster, the following error window
> >> pop up:
> >>
> >> An error has occurred:
> >> ERROR: incompatible library "/usr/lib/pgsql/xxid.so": missing magic block
> >> HINT: Extension libraries are required to use the PG_MODULE_MAGIC macro.
> >>
> >> Is there a way to fix this problem?
> >>
> >
> > That means the version of Slony you have is not built for the version of
> > PostgreSQL you are running. You need to find (or build) a Slony RPM for
> > your specific version of PostgreSQL
> Alright, so I've built SlonyI-1.2 from source and when I tried to add a
> New Slony-I Cluster again, the following error window pop up:
>
> An error has occurred:
> ERROR: RETURN cannot have a parameter in function returning void at or
> near "1"
> LINE 7000: return 1 ;
>
> What is that mean? and how to solve this?
> Thank you.

If you're on Slony 1.2.12, and a modern version of PostgreSQL, then I can think of 2 possibilities:

- This is one of the bugs in pgAdmin 1.6's Slony support. Solution - upgrade to 1.8.

- pgAdmin's Slony path (under File -> Options) is pointing to the old version of the Slony scripts, not the ones from the new version.

Regards, Dave