From: | "Aurelio Campa (ERA)" <aurelio(dot)campa(at)eraltduk(dot)com> |
---|---|
To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | "Slony-I creation scripts not available; only joining possible" - pgAdmin III v 1.20.0 and Slony-I v2.2.4 and Postgresql v9.4.4 |
Date: | 2015-07-01 06:13:36 |
Message-ID: | D1B9439F.14745%aurelio.campa@eraltduk.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Team
This seems like a recurring problem, "Slony-I creation scripts not available; only joining possible".
pgAdmin III v 1.20.0 and Slony-I v2.2.4 and Postgresql v9.4.4
My setup consist of a fresh install,
Windows 2012 R2
Using the Win x86-64 download of postgresql-9.4.4-1-windows-x64 from http://www.enterprisedb.com/products-services-training/pgdownload
Installed
Postgresql 9.4.4
And using Stackbuilder downloaded edb_slony_i_pg94 and installed Slony-I v2.2.4
In pgAdmin III, I point my "Sony-I path" to C:\Program Files\PostgreSQL\9.4\share which is where the .sql files live.
When I select "New Sony-I cluster" I get the pop-up window but at the bottom it says "Slony-I creation scripts not available; only joining possible".
Hence I can't start my configuration.
Below is the output of pg_config on my Windows 2012 R2 machine.
The issue seems to be related to the naming of the .sql files in the share directory and the name of the slony1_funcs.dll file in the lib directory and what it expects to see.
Is there a simple fix to this?
Thanks
Aurelio
(M) +44 (0)7714 215454
(T) +44 (0)207 607 4224
C:\Users\Administrator>pg_config
BINDIR = C:/PROGRA~1/POSTGR~1/9.4/bin
DOCDIR = C:/PROGRA~1/POSTGR~1/9.4/doc
HTMLDIR = C:/PROGRA~1/POSTGR~1/9.4/doc
INCLUDEDIR = C:/PROGRA~1/POSTGR~1/9.4/include
PKGINCLUDEDIR = C:/PROGRA~1/POSTGR~1/9.4/include
INCLUDEDIR-SERVER = C:/PROGRA~1/POSTGR~1/9.4/include/server
LIBDIR = C:/PROGRA~1/POSTGR~1/9.4/lib
PKGLIBDIR = C:/PROGRA~1/POSTGR~1/9.4/lib
LOCALEDIR = C:/PROGRA~1/POSTGR~1/9.4/share/locale
MANDIR = C:/Program Files/PostgreSQL/9.4/man
SHAREDIR = C:/PROGRA~1/POSTGR~1/9.4/share
SYSCONFDIR = C:/Program Files/PostgreSQL/9.4/etc
PGXS = C:/Program Files/PostgreSQL/9.4/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = --enable-thread-safety --enable-integer-datetimes --enable-nls --wit
h-ldap --with-ossp-uuid --with-libxml --with-libxslt --with-tcl --with-perl --wi
th-python
VERSION = PostgreSQL 9.4.4
Aurelio
(M) +44 (0)7714 215454
(T) +44 (0)207 607 4224
______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Landauer | 2015-07-02 10:42:04 | Suggesion: User Interface: Query tool: Match menu command and icon |
Previous Message | Aurelio Campa (ERA) | 2015-06-30 21:52:09 | pgAdmin III v 1.20.0 and Slony-I v2.2.4 and Postgresql v9.4.4 |