Re: Slony scripts

[Dave Page <dpage(at)postgresql(dot)org>]

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.