Re: Slony scripts - Mailing list pgadmin-support

From Dave Page
Subject Re: Slony scripts
Date
Msg-id 45E3F0EA.2000007@postgresql.org
Whole thread Raw
In response to Slony scripts  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: Slony scripts
List pgadmin-support
Raymond O'Donnell wrote:
> Hi all,
> 
> I can't create a Slony cluster from pgAdmin on my laptop, even though -
> 
> (i)  I have Slony-I (1.2.6) installed locally, and
> (ii) Options->General->Slony-I path contains the local share directory,
> which has the Slony SQL scripts.
> 
> When I right-click on a "Replication" node in the Object Browser and
> select "New Slony-I cluster", the status bar still tells me "Slony-I
> creation scripts not available; only joining possible."
> 
> I'm running pgAdmin III 1.6.2 on WinXP SP2.
> 
> What am I missing?

Nothing - you probably just hit two bugs I fixed last week after one of
our pre-sales guys had the same problem, one in pgInstaller, and one in
pgAdmin.

1) pgInstaller installs a script with the wrong name, xxid.sql instead
of the correct xxid.v80.sql

2) pgAdmin looks for the v7.4 versions of the scripts, not the v8.0.

So, the simple answer is to rename xxid.sql to xxid.v80.sql, and then to
copy it to xxid.v74.sql, and copy the slony1_funcs.v80.sql in the same way.

Then try again.

The other option is to wait for the next builds of pgInstaller and
pgAdmin to be released!

Regards, Dave.


pgadmin-support by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Slony scripts
Next
From: "Ezequias Rodrigues da Rocha"
Date:
Subject: Position of a field