Re: Slony scripts

From: Dave Page <dpage(at)postgresql(dot)org>
To: rod(at)iol(dot)ie
Cc: Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Slony scripts
Date: 2007-02-27 08:50:50
Message-ID: 45E3F0EA.2000007@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Ezequias Rodrigues da Rocha 2007-02-27 11:51:27 Position of a field
Previous Message Hiroshi Saito 2007-02-26 22:59:26 Re: Slony scripts