Slony-I creation scripts not available; only joining possible
2
votes
0
answers
2573
views
I try to start Slony replication. I have PostgreSQL 9.3.4, PgAdmin III 1.18.1 and Slony-I 2.2.0-1. I have set the path to Slony to
D:\GIS\PostgreSQL\9.3\share
where I have the Slony files. Whenever I try to create new Slony-I cluster, there is following message on the bottom of the window: Slony-I creation scripts not available; only joining possible
.
When looking for solution, I found a helpful maillist . Especially first post by Neel Patel was helpful:
> Sorry for the late replay, we have checked and it is a bug in pgAdmin
> because the name of the sql files got changed in new slony version (
> v2.2.0 ) which is used by the pgAdmin.
>
> Issue :-
>
> When we install the slony ( version less than 2.2.0 ) then it will
> install below sql files in C:\Program Files\PostgreSQL\9.3\share
> folder.
>
> slony1_base.sql slony1_base.v83.sql slony1_base.v84.sql
> slony1_funcs.sql slony1_funcs.v83.sql slony1_funcs.v84.sql
>
> Now in New version of slony 2.2.0 onwards the name of the above sql
> files got changed as below.
>
> slony1_base.2.2.0.sql slony1_base.v83.2.2.0.sql
> slony1_base.v84.2.2.0.sql slony1_funcs.2.2.0.sql
> slony1_funcs.v83.2.2.0.sql slony1_funcs.v84.2.2.0.sql
>
> As we are using above sql files names in pgAdmin to create the new
> slony clusters so we need to change in pgAdmin also.
Later in the discussion a patch fixing it appeared, but I don't know how to apply it - see my previous question . See that question for the ways I tried.
Is there any way to solve this problem other than to install the patch? Help with installing the patch would be also appreciated, but I would prefer it to appear in the linked answer than here, this question should focus on other ways to solve it.
EDIT: I tested different versions of PostgreSQL and Slony-I (Slony 2.0.7 on PostgreSQL 9.1 and Slony 2.1.3 on PostgreSQL 9.2) and also pgAdmin 1.16. The same problems occurs everywhere.
Asked by Pavel V.
(757 rep)
Apr 16, 2014, 09:20 AM
Last activity: Jul 2, 2014, 08:30 AM
Last activity: Jul 2, 2014, 08:30 AM