Hi Neel, I test the patch with following slony-I versions: 1.2.27 (not working with PG 9.0) 2.0.x (not picking correct slony1_base.xxx.sql - as per comment, it should pick slony1_base.v84.sql with PG 8.4 and above, but picking slony1_base.v83.sql)
I have not tested further. Can you please take a look at it? On Tue, Oct 29, 2013 at 3:38 PM, Dave Page <dave.p...@enterprisedb.com>wrote: > Ashesh, can you look at this one as well please? Thanks. > > On Tue, Oct 22, 2013 at 8:34 AM, Neel Patel <neel.pa...@enterprisedb.com> > wrote: > > Hi Dave, > > > > We have fixed the below two issues to support in Slony version 2.2.0 > with PG > > 9.3 in pgAdmin. > > > > Issue 1:- > > > > Bug to reproduce:- > > > > - Install PG 9.3 and slony 2.2.0 > > - Right click on database and click on option "New slony-I cluster..." > > - In the dialog we are able to see the error in status bar saying > "Slony-I > > creation scripts not available; only joining possible" > > > > Solution :- > > > > As per the above conversation in new version of slony 2.2.0 installation > > name of the sql files got changed so it is not able to find the current > > slony version. > > > > > > Issue 2:- > > > > "storenode" API contains three argument in slony version 1.1 and 1.2 but > in > > slony version 2.0 onwards it contains only two arguments so that issue > also > > fixed. > > > > > > As per our knowledge we have tested this patch in slony 2.2.0 with PG > 9.3. > > > > Can anyone please test this patch and let us know if any bugs. > > > > > > Thanks, > > Neel Patel > > > > > > > > > > > > On Fri, Oct 11, 2013 at 5:17 PM, Neel Patel <neel.pa...@enterprisedb.com > > > > wrote: > >> > >> Hi Sven, > >> > >> No idea regarding the next release. > >> > >> Thanks, > >> Neel Patel > >> > >> > >> On Fri, Oct 11, 2013 at 11:46 AM, Sven Meirsman < > sven.meirs...@gmail.com> > >> wrote: > >>> > >>> Hi, > >>> > >>> Thanks for the feedback. I'm looking forward to this update. Any idea > on > >>> when it will be released? > >>> > >>> regards, > >>> Sven > >>> > >>> > >>> 2013/10/11 Neel Patel <neel.pa...@enterprisedb.com> > >>>> > >>>> Hi Sven, > >>>> > >>>> 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. > >>>> > >>>> We are working on this issue and submit the patch once its done. > >>>> > >>>> Thanks, > >>>> Neel Patel > >>>> > >>>> > >>>> > >>>> On Mon, Sep 30, 2013 at 2:05 AM, Guillaume Lelarge > >>>> <guilla...@lelarge.info> wrote: > >>>>> > >>>>> On Sun, 2013-09-29 at 22:29 +0200, Sven Meirsman wrote: > >>>>> > Sorry, My mistake. > >>>>> > > >>>>> > 'Binary Paths' is the section you choose at the left of the screen. > >>>>> > It > >>>>> > contains several paths, one 'PG Bin Path' is directing to my > postgres > >>>>> > BIN > >>>>> > folder like you suggest. It is the Slony-I path that contains the > >>>>> > path to > >>>>> > the postgres SHARE folder where the slony scripts reside. > >>>>> > > >>>>> > >>>>> Oh OK, you're right. > >>>>> > >>>>> On the Slony issue, I see that Dave commited a patch from Neel Patel > >>>>> last thursday. This patch commit log is: "Ensure DDLScript will work > >>>>> with Slony 2.2+ which has a new SQL level API.". So I guess this is > >>>>> what > >>>>> you're looking for. This will be in the next minor release (1.18.1), > >>>>> which should be available on thursday 10th october. > >>>>> > >>>>> > >>>>> -- > >>>>> Guillaume > >>>>> http://blog.guillaume.lelarge.info > >>>>> http://www.dalibo.com > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> Sent via pgadmin-support mailing list ( > pgadmin-support@postgresql.org) > >>>>> To make changes to your subscription: > >>>>> http://www.postgresql.org/mailpref/pgadmin-support > >>>> > >>>> > >>> > >> > > > > > > -- > Dave Page > Chief Architect, Tools & Installers > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company > > Blog: http://pgsnake.blogspot.com > Twitter: @pgsnake > -- -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company<http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi*<http://www.linkedin.com/in/asheshvashi>
