Thread: Slony scripts
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? Thanks, Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------
Hi. It seems not to be understood easily somewhat....You should register the slon service. Probabry, the first beginning is recommended to use the slonik command. Because the series of operations can be kept. It needs a tedious operation though GUI of pgAdmin3 helps maintenance.:-) Refer to Robert-san page for usage. See. http://people.planetpostgresql.org/xzilla/index.php?/archives/200-Alpha-testing-Slony-on-win32-Crib-Notes.html Regards, Hiroshi Saito > 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?
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.
Dave Page wrote: > 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. That did the trick - good on you! Ray. --------------------------------------------------------------- Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie ---------------------------------------------------------------