Thread: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Sven Meirsman
Date:
Hello,

I am having difficulties getting the slony-i scripts recognized and found by pgAdmin,

I am running
- Windows Server 2003.
- Postgres 9.3 + PostGIS 2.1.0
- pgAdmin 1.18.0
- slony-I 2.2.0

I installed slony-i 2.2.0 using the Application Stack Builder.

In Menu of pgAdmin, I have in File->Options->Binary Paths the value "c:/program files/postgreSQL/9.3/share".

This folder contains 6 .SQL files belonging to slony-i.

When trying to add a new Slony-I cluster, the popup windows keeps telling me 'Slony-I creation scripts not available; only joining possible'. However, like stated above, things are setup correctly.

Can someone help me out on this issue?

regards,
Sven

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Guillaume Lelarge
Date:
On Sun, 2013-09-29 at 21:13 +0200, Sven Meirsman wrote:
> Hello,
> 
> I am having difficulties getting the slony-i scripts recognized and found
> by pgAdmin,
> 
> I am running
> - Windows Server 2003.
> - Postgres 9.3 + PostGIS 2.1.0
> - pgAdmin 1.18.0
> - slony-I 2.2.0
> 
> I installed slony-i 2.2.0 using the Application Stack Builder.
> 
> In Menu of pgAdmin, I have in File->Options->Binary Paths the value
> "c:/program files/postgreSQL/9.3/share".
> 
> This folder contains 6 .SQL files belonging to slony-i.
> 
> When trying to add a new Slony-I cluster, the popup windows keeps telling
> me 'Slony-I creation scripts not available; only joining possible'.
> However, like stated above, things are setup correctly.
> 
> Can someone help me out on this issue?
> 

Specifically on the slony part, I can't do much, but I find it weird
that your binary path points to a share directory. There's good chance
it should be "c:/program files/postgreSQL/9.3/bin".


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com




Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Sven Meirsman
Date:
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.

Sven


2013/9/29 Guillaume Lelarge <guillaume@lelarge.info>
On Sun, 2013-09-29 at 21:13 +0200, Sven Meirsman wrote:
> Hello,
>
> I am having difficulties getting the slony-i scripts recognized and found
> by pgAdmin,
>
> I am running
> - Windows Server 2003.
> - Postgres 9.3 + PostGIS 2.1.0
> - pgAdmin 1.18.0
> - slony-I 2.2.0
>
> I installed slony-i 2.2.0 using the Application Stack Builder.
>
> In Menu of pgAdmin, I have in File->Options->Binary Paths the value
> "c:/program files/postgreSQL/9.3/share".
>
> This folder contains 6 .SQL files belonging to slony-i.
>
> When trying to add a new Slony-I cluster, the popup windows keeps telling
> me 'Slony-I creation scripts not available; only joining possible'.
> However, like stated above, things are setup correctly.
>
> Can someone help me out on this issue?
>

Specifically on the slony part, I can't do much, but I find it weird
that your binary path points to a share directory. There's good chance
it should be "c:/program files/postgreSQL/9.3/bin".


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Guillaume Lelarge
Date:
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




Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Neel Patel
Date:
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 <guillaume@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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Sven Meirsman
Date:
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.patel@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 <guillaume@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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Neel Patel
Date:
Hi Sven,

No idea regarding the next release.

Thanks,
Neel Patel


On Fri, Oct 11, 2013 at 11:46 AM, Sven Meirsman <sven.meirsman@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.patel@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 <guillaume@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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support



Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Neel Patel
Date:
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.patel@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.meirsman@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.patel@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 <guillaume@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.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support




Attachment

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
demaseme
Date:
Hi, I'd be more than glad to test out, but how can I install the .patch file? 




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/pgAdmin-1-18-0-slony-I-2-2-0-PG-9-3-tp5772774p5775445.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.



Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Dave Page
Date:
Ashesh, can you look at this one as well please? Thanks.

On Tue, Oct 22, 2013 at 8:34 AM, Neel Patel <neel.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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


Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Ashesh Vashi
Date:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Neel Patel
Date:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi


Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Neel Patel
Date:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi



Attachment

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Dinesh Kumar
Date:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Dinesh Kumar
Date:
Hi Dave/Team,

I would like to take the ownership of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. 

ERROR:  column sa.procpid does not exist
LINE 1: .. nl, pg_stat_activity sa WHERE nl.nl_backendpid = sa.procpid.

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh
Attachment

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Dave Page
Date:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Ashesh Vashi
Date:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Akshay Joshi
Date:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Sanket Mehta
Date:
Hi Dave,

I have reviewed the older patch, it looked good to me except one issue that I have fixed.
I have attached the revised patch with this mail.



Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 27, 2014 at 3:16 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

Attachment

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Dave Page
Date:
Ashesh, can you review/commit this please?

On Mon, Oct 27, 2014 at 9:56 AM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
Hi Dave,

I have reviewed the older patch, it looked good to me except one issue that I have fixed.
I have attached the revised patch with this mail.



Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 27, 2014 at 3:16 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Ashesh Vashi
Date:

On Mon, Oct 27, 2014 at 4:16 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh, can you review/commit this please?
Sure Dave.
I/Akshay will review the patch asap.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Mon, Oct 27, 2014 at 9:56 AM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
Hi Dave,

I have reviewed the older patch, it looked good to me except one issue that I have fixed.
I have attached the revised patch with this mail.



Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 27, 2014 at 3:16 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Akshay Joshi
Date:


On Mon, Oct 27, 2014 at 4:22 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:

On Mon, Oct 27, 2014 at 4:16 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh, can you review/commit this please?
Sure Dave.
I/Akshay will review the patch asap.

   I have reviewed the patch and it looks good to me. 


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Mon, Oct 27, 2014 at 9:56 AM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
Hi Dave,

I have reviewed the older patch, it looked good to me except one issue that I have fixed.
I have attached the revised patch with this mail.



Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 27, 2014 at 3:16 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Ashesh Vashi
Date:
Thanks everybody for your contribution.
We've committed the patch in the master branch.

Dave,

Do we need to check-in this in the REL-1_18_0_PATCHES branch?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


On Mon, Oct 27, 2014 at 4:28 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:


On Mon, Oct 27, 2014 at 4:22 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:

On Mon, Oct 27, 2014 at 4:16 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh, can you review/commit this please?
Sure Dave.
I/Akshay will review the patch asap.

   I have reviewed the patch and it looks good to me. 


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Mon, Oct 27, 2014 at 9:56 AM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
Hi Dave,

I have reviewed the older patch, it looked good to me except one issue that I have fixed.
I have attached the revised patch with this mail.



Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 27, 2014 at 3:16 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

Re: [pgadmin-hackers] pgAdmin 1.18.0 + slony-I 2.2.0 + PG 9.3

From
Dave Page
Date:
No point - we're not going to release another 1.18 version.

On Thu, Oct 30, 2014 at 5:53 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Thanks everybody for your contribution.
We've committed the patch in the master branch.

Dave,

Do we need to check-in this in the REL-1_18_0_PATCHES branch?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


On Mon, Oct 27, 2014 at 4:28 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:


On Mon, Oct 27, 2014 at 4:22 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:

On Mon, Oct 27, 2014 at 4:16 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh, can you review/commit this please?
Sure Dave.
I/Akshay will review the patch asap.

   I have reviewed the patch and it looks good to me. 


--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi



On Mon, Oct 27, 2014 at 9:56 AM, Sanket Mehta <sanket.mehta@enterprisedb.com> wrote:
Hi Dave,

I have reviewed the older patch, it looked good to me except one issue that I have fixed.
I have attached the revised patch with this mail.



Regards,
Sanket Mehta
Sr Software engineer
Enterprisedb

On Mon, Oct 27, 2014 at 3:16 PM, Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Adding Sanket

He has already worked on it.

On Tue, Feb 11, 2014 at 10:35 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Sure


On Mon, Feb 10, 2014 at 8:00 PM, Dave Page <dpage@pgadmin.org> wrote:
Ashesh; can you review this please?

Thanks.


On Fri, Feb 7, 2014 at 9:17 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Dave/Team,

I would like to take the owner ship of this patch from now onwards.

Sorry for my previous test case result, which is an improper one from my side. I believe, i need to configure the same slony version on PG 9.2 as well. It seems an expected behaviour if the slony version is not match.

And also i have fixed one small version bug as below.

BUG Details
------------------
After configuring the slony on PG 9.2 server follow the below steps.

1. Launch pgadmin III
2. Add New server and Right Click on Slony cluster node
3. Click on Restart node
4. Error occurred regarding procpid does not exist. (Image is attached)

I have fixed this trivial bug on top of Neel's patch, and sending single patch for these two issues.

Kindly let me know, if i miss anything here.

Thanks in advance.

Regards,
Dinesh

-- 
Dinesh Kumar
Software Engineer
Skype ID: dinesh.kumar432
www.enterprisedb.com

Follow us on Twitter

@EnterpriseDB 

Visit EnterpriseDB for tutorials, webinars, whitepapers and more


On Tue, Dec 10, 2013 at 2:49 AM, Dinesh Kumar <dinesh.kumar@enterprisedb.com> wrote:
Hi Neel,

On Mon, Nov 11, 2013 at 6:46 PM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi Ashesh,

Please find the updated patch with below fix.

-- Fix for slony version 1.2.23 with PG 9.0
-- Picking the correct version of slony1_base.xxx.sql
-- Fix the error "no schema has been selected to create in". It gives error after deleting the slony cluster and again create the    new slony cluster.
-- Fix for function storeNode() API which is accepting three arguments in slony version 1.1 and 1.2 and two arguments in 
   slony version 2.0 and above.

Please let me know for any comments.

I have tested this patch, and seems working fine. I have found one small issue when i try to create a new slony cluster with PG 9.2. When i am trying to create a new cluster in PG 9.2 by setting the slony-path of PG 9.3, then it' showing the
"ERROR:  could not access file "$libdir/slony1_funcs.2.2.0": No such file or directory"
.

Could you look into this as well.

Thanks,
Dinesh
 

Thanks,
Neel Patel


On Thu, Oct 31, 2013 at 9:41 AM, Neel Patel <neel.patel@enterprisedb.com> wrote:
Hi,

Thanks Ashesh.

I will check and let you know.

Thanks,
Neel Patel


On Wed, Oct 30, 2013 at 5:19 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
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.page@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.patel@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.patel@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.meirsman@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.patel@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
>>>> <guillaume@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.linkedin.com/in/asheshvashi





--
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

Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



--
--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA:
Enterprise PostgreSQL Company

 

http://www.linkedin.com/in/asheshvashi




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company




--
Akshay Joshi
Principal Software Engineer 


Phone: +91 20-3058-9517
Mobile: +91 976-788-8246




--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company