Re: v2.0 RC2 test builds

[Surinder Kumar]

​Hi​

On Tue, Sep 19, 2017 at 4:29 PM, Dave Page  wrote:

> Is this accurate?
>
> https://www.pgadmin.org/faq/#9
>
​Yes​


>
>
> On Tue, Sep 19, 2017 at 10:58 AM, Dave Page  wrote:
>
>>
>>
>> On Tue, Sep 19, 2017 at 10:21 AM, Surinder Kumar <
>> surinder.ku...@enterprisedb.com> wrote:
>>
>>> Hi
>>> On Tue, Sep 19, 2017 at 1:51 PM, Dave Page  wrote:
>>>
 I assume that's the same as:

 Allow apps downloaded from:

  [ ] App Store
  [x] Apps Store and identified developers

>>> ​I see the same settings with second options ticked in my machine. but
>>> the error message "pgAdmin4 is damaged and can't be opened. You should
>>> eject the disk image" doesn't gives the clue to user to tick the settings
>>> "Allow apps downloaded from: anywhere".
>>>
>>> Can this message be changed or it is system defined?
>>>
>>
>> It's system defined :-(.
>>
>>
>>
>>>
>>>
 In later releases of macOS?


 On Tue, Sep 19, 2017 at 8:12 AM, Surinder Kumar <
 surinder.ku...@enterprisedb.com> wrote:

> Hi Fahar,
>
> It gets installed successfully when I checked the option "Allow apps
> downloaded from" to "Anywhere" in Security & Privacy option.
> However, If I install another downloaded app, It asks the user to
> enable the install for this app by going to Security & Privacy option.
>
> Thanks to Khushboo for help.
>
> On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas <
> fahar.ab...@enterprisedb.com> wrote:
>
>> Hi Surinder,
>>
>> I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue
>> related to this.
>>
>> Steps:
>> 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on
>> MAC 10.10 fresh VM.
>>
>> Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped
>> this support.
>>
>> Can you please share the exact steps so it could reproduce on my
>> fresh VM?
>>
>> Kind Regards,
>>
>>
>> On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
>> surinder.ku...@enterprisedb.com> wrote:
>>
>>> Hi
>>>
>>> Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
>>> )
>>> for Mac but it is failed to open. When I double click on pgAdmin4 icon 
>>> to
>>> open pgAdmin4, I got an error, please refer the screenshot attached.
>>>
>>> *OS details:*
>>>
>>> Mac OS X Yosemite
>>> Version 10.10.2
>>>
>>> Even on Akshay's machine pgAdmin4 doesn't open
>>>
>>> *OS details:*
>>>
>>> Mac OS X Mavericks
>>> Version 10.09.05
>>>
>>> *Error:*
>>>
>>> The application server couldn't be contacted.
>>>
>>> @Fahar, Can you please verify If you got same error?
>>>
>>> Thanks,
>>> Surinder
>>>
>>>
>>> On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros <
>>> adebar...@gmail.com> wrote:
>>>
 No show-stoppers to report. Just to say that it looks great and
 loads fast. Nice work!

 Only stylistic item is that the column names in the result grid
 used to be bold but are now the same weight as the data type.

 Anthony


 On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
 wrote:

 I've put v2.0-rc2 test builds at https://developer.pgadmin.o
 rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
 show-stopper issues ASAP!

 Devrim; these includes the WSGI fix needed for the problem I ran
 into when testing the RPMs in web mode.

 Thanks.

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

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


>>>
>>
>>
>> --
>> Fahar Abbas
>> QMG
>> EnterpriseDB Corporation
>> Phone Office: +92-51-835-8874
>> Phone Direct: +92-51-8466803 <+92%2051%208466803>
>> Mobile: +92-333-5409707 <+92%20333%205409707>
>> Skype ID: syed.fahar.abbas
>> Website: www.enterprisedb.com
>>
>
>


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

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

>>>
>>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

Re: pgAdmin 4 commit: Bundle fonts with pgAdmin so we have a standard set f

[Murtuza Zabuawala]

Hi Dave,

Please find patch to fix the font on alertify header.
Please review.

--
Regards,
Murtuza Zabuawala

On Fri, Sep 15, 2017 at 7:10 PM, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> Hi Atul,
>
> I think we still missed alertify header fonts :)
> Check screenshot.
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> [image: https://community.postgresrocks.net/]
> 
>
> On Fri, Sep 15, 2017 at 6:38 PM, Dave Page  wrote:
>
>> Thanks, applied.
>>
>> On Fri, Sep 15, 2017 at 8:59 AM, Atul Sharma <
>> atul.sha...@enterprisedb.com> wrote:
>>
>>> Hi,
>>>
>>> PFA patch which replaces the "Roboto" font family with "Open Sans" for
>>> alertify dialogs. Regarding Query tool context menu, It seems different
>>> issue than the applied fonts.
>>>
>>> Regards,
>>> Atul
>>>
>>> On Thu, Sep 14, 2017 at 7:49 PM, Murtuza Zabuawala <
>>> murtuza.zabuaw...@enterprisedb.com> wrote:
>>>
 Attaching more screenshots.

 --
 Regards,
 Murtuza Zabuawala
 EnterpriseDB: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company

 [image: https://community.postgresrocks.net/]
 

 On Thu, Sep 14, 2017 at 7:08 PM, Murtuza Zabuawala <
 murtuza.zabuaw...@enterprisedb.com> wrote:

> Hi Atul,
>
> Please also check fonts in various the alertify dialogs.
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> [image: https://community.postgresrocks.net/]
> 
>
> On Thu, Sep 14, 2017 at 7:03 PM, Dave Page  wrote:
>
>> Nope - it shouldn't look like that. Atul, Can you take a look at it
>> please?
>>
>> On Thu, Sep 14, 2017 at 2:26 PM, Murtuza Zabuawala <
>> murtuza.zabuaw...@enterprisedb.com> wrote:
>>
>>> Hi Dave,
>>>
>>> After latest pull fonts from context menu looks different, PFA
>>> screenshot.
>>> I tried on macOS: 10.10 (Web mode) on Google Chrome: Version
>>> 60.0.3112.113 (Official Build) (64-bit)
>>>
>>> Is this expected behaviour?
>>>
>>>
>>> --
>>> Regards,
>>> Murtuza Zabuawala
>>> EnterpriseDB: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>> [image: https://community.postgresrocks.net/]
>>> 
>>>
>>> On Wed, Sep 13, 2017 at 8:31 PM, Dave Page 
>>> wrote:
>>>
 Bundle fonts with pgAdmin so we have a standard set for all
 platforms.

 Research by Shirley at Pivotal.

 Branch
 --
 master

 Details
 ---
 https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdif
 f;h=788f7f3a69500c37008dbba459d3ea00b0b1bff8
 Author: Atul Sharma 

 Modified Files
 --
 libraries.txt  |   4 ++-
 web/pgadmin/browser/static/css/browser.css |  33
 ++---
 .../misc/bgprocess/static/css/bgprocess.css|   2 +-
 .../misc/file_manager/static/css/file_manager.css  |   2 +-
 web/pgadmin/static/css/aci_tree.overrides.css  |   4 +--
 web/pgadmin/static/css/bootstrap.overrides.css |   5 ++--
 web/pgadmin/static/css/codemirror.overrides.css|   4 +--
 web/pgadmin/static/css/pgadmin.css |  17
 ++-
 web/pgadmin/static/css/pgadmin.style.css   |  10 +++
 web/pgadmin/static/css/webcabin.overrides.css  |   6 ++--
 web/pgadmin/static/fonts/OpenSans-Bold.ttf | Bin 0 ->
 224452 bytes
 web/pgadmin/static/fonts/OpenSans-Italic.ttf   | Bin 0 ->
 212760 bytes
 web/pgadmin/static/fonts/OpenSans-Regular.ttf  | Bin 0 ->
 217276 bytes
 web/pgadmin/static/fonts/OpenSans-SemiBold.ttf | Bin 0 ->
 221164 bytes
 web/pgadmin/static/fonts/SourceCodePro-Bold.ttf| Bin 0 ->
 120504 bytes
 web/pgadmin/static/fonts/SourceCodePro-Regular.ttf | Bin 0 ->
 120548 bytes
 web/pgadmin/static/scss/_alert.scss|   2 +-
 web/pgadmin/static/scss/_alertify.overrides.scss   |   2 +-
 web/pgadmin/static/scss/_typography.scss   |   2 +-
 web/pgadmin/static/scss/sqleditor/_history.scss|   8 ++---
 web/pgadmin/tools/debugger/static/css/debugger.css |   6 ++--
 .../tools/sqleditor/static/css/sqleditor.css   |   8 ++---
 22 files changed, 73 insertions(+), 42 deletions(-)


>>>
>>

Re: v2.0 RC2 test builds

[Dave Page]

On Tue, Sep 19, 2017 at 12:10 PM, Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> The setting which worked for me is "*Anywhere", not "**App Store and
> identified developers" for me*.
>

Hmm, I don't have such an option on 10.12. I'll see if I can re-word to
account for that.


>
> On Tue, Sep 19, 2017 at 4:29 PM, Dave Page  wrote:
>
>> Is this accurate?
>>
>> https://www.pgadmin.org/faq/#9
>>
>> On Tue, Sep 19, 2017 at 10:58 AM, Dave Page  wrote:
>>
>>>
>>>
>>> On Tue, Sep 19, 2017 at 10:21 AM, Surinder Kumar <
>>> surinder.ku...@enterprisedb.com> wrote:
>>>
 Hi
 On Tue, Sep 19, 2017 at 1:51 PM, Dave Page  wrote:

> I assume that's the same as:
>
> Allow apps downloaded from:
>
>  [ ] App Store
>  [x] Apps Store and identified developers
>
 ​I see the same settings with second options ticked in my machine. but
 the error message "pgAdmin4 is damaged and can't be opened. You should
 eject the disk image" doesn't gives the clue to user to tick the settings
 "Allow apps downloaded from: anywhere".

 Can this message be changed or it is system defined?

>>>
>>> It's system defined :-(.
>>>
>>>
>>>


> In later releases of macOS?
>
>
> On Tue, Sep 19, 2017 at 8:12 AM, Surinder Kumar <
> surinder.ku...@enterprisedb.com> wrote:
>
>> Hi Fahar,
>>
>> It gets installed successfully when I checked the option "Allow apps
>> downloaded from" to "Anywhere" in Security & Privacy option.
>> However, If I install another downloaded app, It asks the user to
>> enable the install for this app by going to Security & Privacy option.
>>
>> Thanks to Khushboo for help.
>>
>> On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas <
>> fahar.ab...@enterprisedb.com> wrote:
>>
>>> Hi Surinder,
>>>
>>> I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue
>>> related to this.
>>>
>>> Steps:
>>> 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on
>>> MAC 10.10 fresh VM.
>>>
>>> Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped
>>> this support.
>>>
>>> Can you please share the exact steps so it could reproduce on my
>>> fresh VM?
>>>
>>> Kind Regards,
>>>
>>>
>>> On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
>>> surinder.ku...@enterprisedb.com> wrote:
>>>
 Hi

 Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
 )
 for Mac but it is failed to open. When I double click on pgAdmin4 icon 
 to
 open pgAdmin4, I got an error, please refer the screenshot attached.

 *OS details:*

 Mac OS X Yosemite
 Version 10.10.2

 Even on Akshay's machine pgAdmin4 doesn't open

 *OS details:*

 Mac OS X Mavericks
 Version 10.09.05

 *Error:*

 The application server couldn't be contacted.

 @Fahar, Can you please verify If you got same error?

 Thanks,
 Surinder


 On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros <
 adebar...@gmail.com> wrote:

> No show-stoppers to report. Just to say that it looks great and
> loads fast. Nice work!
>
> Only stylistic item is that the column names in the result grid
> used to be bold but are now the same weight as the data type.
>
> Anthony
>
>
> On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
> wrote:
>
> I've put v2.0-rc2 test builds at https://developer.pgadmin.o
> rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
> show-stopper issues ASAP!
>
> Devrim; these includes the WSGI fix needed for the problem I ran
> into when testing the RPMs in web mode.
>
> Thanks.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>

>>>
>>>
>>> --
>>> Fahar Abbas
>>> QMG
>>> EnterpriseDB Corporation
>>> Phone Office: +92-51-835-8874
>>> Phone Direct: +92-51-8466803 <+92%2051%208466803>
>>> Mobile: +92-333-5409707 <+92%20333%205409707>
>>> Skype ID: syed.fahar.abbas
>>> Website: www.enterprisedb.com
>>>
>>
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


>>>

Re: v2.0 RC2 test builds

[Dave Page]

Is this accurate?

https://www.pgadmin.org/faq/#9

On Tue, Sep 19, 2017 at 10:58 AM, Dave Page  wrote:

>
>
> On Tue, Sep 19, 2017 at 10:21 AM, Surinder Kumar <
> surinder.ku...@enterprisedb.com> wrote:
>
>> Hi
>> On Tue, Sep 19, 2017 at 1:51 PM, Dave Page  wrote:
>>
>>> I assume that's the same as:
>>>
>>> Allow apps downloaded from:
>>>
>>>  [ ] App Store
>>>  [x] Apps Store and identified developers
>>>
>> ​I see the same settings with second options ticked in my machine. but
>> the error message "pgAdmin4 is damaged and can't be opened. You should
>> eject the disk image" doesn't gives the clue to user to tick the settings
>> "Allow apps downloaded from: anywhere".
>>
>> Can this message be changed or it is system defined?
>>
>
> It's system defined :-(.
>
>
>
>>
>>
>>> In later releases of macOS?
>>>
>>>
>>> On Tue, Sep 19, 2017 at 8:12 AM, Surinder Kumar <
>>> surinder.ku...@enterprisedb.com> wrote:
>>>
 Hi Fahar,

 It gets installed successfully when I checked the option "Allow apps
 downloaded from" to "Anywhere" in Security & Privacy option.
 However, If I install another downloaded app, It asks the user to
 enable the install for this app by going to Security & Privacy option.

 Thanks to Khushboo for help.

 On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas <
 fahar.ab...@enterprisedb.com> wrote:

> Hi Surinder,
>
> I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue related
> to this.
>
> Steps:
> 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on
> MAC 10.10 fresh VM.
>
> Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped
> this support.
>
> Can you please share the exact steps so it could reproduce on my fresh
> VM?
>
> Kind Regards,
>
>
> On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
> surinder.ku...@enterprisedb.com> wrote:
>
>> Hi
>>
>> Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
>> )
>> for Mac but it is failed to open. When I double click on pgAdmin4 icon to
>> open pgAdmin4, I got an error, please refer the screenshot attached.
>>
>> *OS details:*
>>
>> Mac OS X Yosemite
>> Version 10.10.2
>>
>> Even on Akshay's machine pgAdmin4 doesn't open
>>
>> *OS details:*
>>
>> Mac OS X Mavericks
>> Version 10.09.05
>>
>> *Error:*
>>
>> The application server couldn't be contacted.
>>
>> @Fahar, Can you please verify If you got same error?
>>
>> Thanks,
>> Surinder
>>
>>
>> On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros <
>> adebar...@gmail.com> wrote:
>>
>>> No show-stoppers to report. Just to say that it looks great and
>>> loads fast. Nice work!
>>>
>>> Only stylistic item is that the column names in the result grid used
>>> to be bold but are now the same weight as the data type.
>>>
>>> Anthony
>>>
>>>
>>> On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
>>> wrote:
>>>
>>> I've put v2.0-rc2 test builds at https://developer.pgadmin.o
>>> rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
>>> show-stopper issues ASAP!
>>>
>>> Devrim; these includes the WSGI fix needed for the problem I ran
>>> into when testing the RPMs in web mode.
>>>
>>> Thanks.
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>>
>>
>
>
> --
> Fahar Abbas
> QMG
> EnterpriseDB Corporation
> Phone Office: +92-51-835-8874
> Phone Direct: +92-51-8466803 <+92%2051%208466803>
> Mobile: +92-333-5409707 <+92%20333%205409707>
> Skype ID: syed.fahar.abbas
> Website: www.enterprisedb.com
>


>>>
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



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

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

[pgAdmin4][Patch] RM 2673 Error not displaying in proper format in User management and Grant Wizard

[Akshay Joshi]

Hi

Attached is the patch file to fix RM 2673 "Error not displaying in proper
format in User management and Grant Wizard". Patch contains fix for Grant
Wizard, as fix for user management is already committed.

-- 
*Akshay Joshi*
*Principal Software Engineer *



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


RM_2673.patch
Description: Binary data

Re: v2.0 RC2 test builds

[Dave Page]

On Tue, Sep 19, 2017 at 10:21 AM, Surinder Kumar <
surinder.ku...@enterprisedb.com> wrote:

> Hi
> On Tue, Sep 19, 2017 at 1:51 PM, Dave Page  wrote:
>
>> I assume that's the same as:
>>
>> Allow apps downloaded from:
>>
>>  [ ] App Store
>>  [x] Apps Store and identified developers
>>
> ​I see the same settings with second options ticked in my machine. but the
> error message "pgAdmin4 is damaged and can't be opened. You should eject
> the disk image" doesn't gives the clue to user to tick the settings "Allow
> apps downloaded from: anywhere".
>
> Can this message be changed or it is system defined?
>

It's system defined :-(.



>
>
>> In later releases of macOS?
>>
>>
>> On Tue, Sep 19, 2017 at 8:12 AM, Surinder Kumar <
>> surinder.ku...@enterprisedb.com> wrote:
>>
>>> Hi Fahar,
>>>
>>> It gets installed successfully when I checked the option "Allow apps
>>> downloaded from" to "Anywhere" in Security & Privacy option.
>>> However, If I install another downloaded app, It asks the user to enable
>>> the install for this app by going to Security & Privacy option.
>>>
>>> Thanks to Khushboo for help.
>>>
>>> On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas <
>>> fahar.ab...@enterprisedb.com> wrote:
>>>
 Hi Surinder,

 I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue related
 to this.

 Steps:
 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on MAC
 10.10 fresh VM.

 Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped
 this support.

 Can you please share the exact steps so it could reproduce on my fresh
 VM?

 Kind Regards,


 On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
 surinder.ku...@enterprisedb.com> wrote:

> Hi
>
> Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
> )
> for Mac but it is failed to open. When I double click on pgAdmin4 icon to
> open pgAdmin4, I got an error, please refer the screenshot attached.
>
> *OS details:*
>
> Mac OS X Yosemite
> Version 10.10.2
>
> Even on Akshay's machine pgAdmin4 doesn't open
>
> *OS details:*
>
> Mac OS X Mavericks
> Version 10.09.05
>
> *Error:*
>
> The application server couldn't be contacted.
>
> @Fahar, Can you please verify If you got same error?
>
> Thanks,
> Surinder
>
>
> On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros  > wrote:
>
>> No show-stoppers to report. Just to say that it looks great and loads
>> fast. Nice work!
>>
>> Only stylistic item is that the column names in the result grid used
>> to be bold but are now the same weight as the data type.
>>
>> Anthony
>>
>>
>> On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
>> wrote:
>>
>> I've put v2.0-rc2 test builds at https://developer.pgadmin.o
>> rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
>> show-stopper issues ASAP!
>>
>> Devrim; these includes the WSGI fix needed for the problem I ran into
>> when testing the RPMs in web mode.
>>
>> Thanks.
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>


 --
 Fahar Abbas
 QMG
 EnterpriseDB Corporation
 Phone Office: +92-51-835-8874
 Phone Direct: +92-51-8466803 <+92%2051%208466803>
 Mobile: +92-333-5409707 <+92%20333%205409707>
 Skype ID: syed.fahar.abbas
 Website: www.enterprisedb.com

>>>
>>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>


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

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

Re: v2.0 RC2 test builds

[Surinder Kumar]

Hi
On Tue, Sep 19, 2017 at 1:51 PM, Dave Page  wrote:

> I assume that's the same as:
>
> Allow apps downloaded from:
>
>  [ ] App Store
>  [x] Apps Store and identified developers
>
​I see the same settings with second options ticked in my machine. but the
error message "pgAdmin4 is damaged and can't be opened. You should eject
the disk image" doesn't gives the clue to user to tick the settings "Allow
apps downloaded from: anywhere".

Can this message be changed or it is system defined?


> In later releases of macOS?
>
>
> On Tue, Sep 19, 2017 at 8:12 AM, Surinder Kumar <
> surinder.ku...@enterprisedb.com> wrote:
>
>> Hi Fahar,
>>
>> It gets installed successfully when I checked the option "Allow apps
>> downloaded from" to "Anywhere" in Security & Privacy option.
>> However, If I install another downloaded app, It asks the user to enable
>> the install for this app by going to Security & Privacy option.
>>
>> Thanks to Khushboo for help.
>>
>> On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas <
>> fahar.ab...@enterprisedb.com> wrote:
>>
>>> Hi Surinder,
>>>
>>> I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue related
>>> to this.
>>>
>>> Steps:
>>> 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on MAC
>>> 10.10 fresh VM.
>>>
>>> Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped
>>> this support.
>>>
>>> Can you please share the exact steps so it could reproduce on my fresh
>>> VM?
>>>
>>> Kind Regards,
>>>
>>>
>>> On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
>>> surinder.ku...@enterprisedb.com> wrote:
>>>
 Hi

 Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
 )
 for Mac but it is failed to open. When I double click on pgAdmin4 icon to
 open pgAdmin4, I got an error, please refer the screenshot attached.

 *OS details:*

 Mac OS X Yosemite
 Version 10.10.2

 Even on Akshay's machine pgAdmin4 doesn't open

 *OS details:*

 Mac OS X Mavericks
 Version 10.09.05

 *Error:*

 The application server couldn't be contacted.

 @Fahar, Can you please verify If you got same error?

 Thanks,
 Surinder


 On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros 
 wrote:

> No show-stoppers to report. Just to say that it looks great and loads
> fast. Nice work!
>
> Only stylistic item is that the column names in the result grid used
> to be bold but are now the same weight as the data type.
>
> Anthony
>
>
> On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
> wrote:
>
> I've put v2.0-rc2 test builds at https://developer.pgadmin.o
> rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
> show-stopper issues ASAP!
>
> Devrim; these includes the WSGI fix needed for the problem I ran into
> when testing the RPMs in web mode.
>
> Thanks.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>

>>>
>>>
>>> --
>>> Fahar Abbas
>>> QMG
>>> EnterpriseDB Corporation
>>> Phone Office: +92-51-835-8874
>>> Phone Direct: +92-51-8466803 <+92%2051%208466803>
>>> Mobile: +92-333-5409707 <+92%20333%205409707>
>>> Skype ID: syed.fahar.abbas
>>> Website: www.enterprisedb.com
>>>
>>
>>
>
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

Re: Postgres 9.6 Logical and Fisical replication

[Ashesh Vashi]

Hi,

This is a pgAdmin specific mailing list.
Please send your mail to pgsql-gene...@postgresql.org.

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company



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


On Tue, Sep 19, 2017 at 3:00 AM, guedim  wrote:

> Hi guys
>
> I am working with Postgres9.6 with a Master/Slave cluster replication using
> Streaming replication.
> I would like to add a new Slave server database but this database with
> logical replication .
>
>
> I tried with some configurations but it was not possible  :(
>
> https://github.com/guedim/postgres-streaming-replication
>
>
> Here is the image of what is in my mind:
> 
>
> Thanks for any help!
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-pgadmin-
> hackers-f2155306.html
>
>

Re: v2.0 RC2 test builds

[Dave Page]

I assume that's the same as:

Allow apps downloaded from:

 [ ] App Store
 [x] Apps Store and identified developers

In later releases of macOS?

On Tue, Sep 19, 2017 at 8:12 AM, Surinder Kumar <
surinder.ku...@enterprisedb.com> wrote:

> Hi Fahar,
>
> It gets installed successfully when I checked the option "Allow apps
> downloaded from" to "Anywhere" in Security & Privacy option.
> However, If I install another downloaded app, It asks the user to enable
> the install for this app by going to Security & Privacy option.
>
> Thanks to Khushboo for help.
>
> On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas <
> fahar.ab...@enterprisedb.com> wrote:
>
>> Hi Surinder,
>>
>> I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue related to
>> this.
>>
>> Steps:
>> 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on MAC
>> 10.10 fresh VM.
>>
>> Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped this
>> support.
>>
>> Can you please share the exact steps so it could reproduce on my fresh VM?
>>
>> Kind Regards,
>>
>>
>> On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
>> surinder.ku...@enterprisedb.com> wrote:
>>
>>> Hi
>>>
>>> Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
>>> )
>>> for Mac but it is failed to open. When I double click on pgAdmin4 icon to
>>> open pgAdmin4, I got an error, please refer the screenshot attached.
>>>
>>> *OS details:*
>>>
>>> Mac OS X Yosemite
>>> Version 10.10.2
>>>
>>> Even on Akshay's machine pgAdmin4 doesn't open
>>>
>>> *OS details:*
>>>
>>> Mac OS X Mavericks
>>> Version 10.09.05
>>>
>>> *Error:*
>>>
>>> The application server couldn't be contacted.
>>>
>>> @Fahar, Can you please verify If you got same error?
>>>
>>> Thanks,
>>> Surinder
>>>
>>>
>>> On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros 
>>> wrote:
>>>
 No show-stoppers to report. Just to say that it looks great and loads
 fast. Nice work!

 Only stylistic item is that the column names in the result grid used to
 be bold but are now the same weight as the data type.

 Anthony


 On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
 wrote:

 I've put v2.0-rc2 test builds at https://developer.pgadmin.o
 rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
 show-stopper issues ASAP!

 Devrim; these includes the WSGI fix needed for the problem I ran into
 when testing the RPMs in web mode.

 Thanks.

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

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


>>>
>>
>>
>> --
>> Fahar Abbas
>> QMG
>> EnterpriseDB Corporation
>> Phone Office: +92-51-835-8874
>> Phone Direct: +92-51-8466803 <+92%2051%208466803>
>> Mobile: +92-333-5409707 <+92%20333%205409707>
>> Skype ID: syed.fahar.abbas
>> Website: www.enterprisedb.com
>>
>
>


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

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

Postgres 9.6 Logical and Fisical replication

[guedim]

Hi guys

I am working with Postgres9.6 with a Master/Slave cluster replication using
Streaming replication.
I would like to add a new Slave server database but this database with
logical replication .


I tried with some configurations but it was not possible  :(

https://github.com/guedim/postgres-streaming-replication


Here is the image of what is in my mind: 
 

Thanks for any help!



--
Sent from: 
http://www.postgresql-archive.org/PostgreSQL-pgadmin-hackers-f2155306.html

Postgres 9.6 Logical and Fisical replication

[guedim]

Hi guys

I am working with Postgres9.6 with a Master/Slave cluster replication using
Streaming replication.
I would like to add a new Slave server database but this database with
logical replication .


I tried with some configurations but it was not possible  :(

https://github.com/guedim/postgres-streaming-replication


Here is the image of what is in my mind: 

 

Thanks for any help!



--
Sent from: 
http://www.postgresql-archive.org/PostgreSQL-pgadmin-hackers-f2155306.html

Re: [pgAdmin4][Patch]: Fix the logic to extract the error in Query tool

[Murtuza Zabuawala]

Hi Dave,

Please find updated patch, I have tested following scenarios in query tool,
1) To test if we highlight faulty syntax
SQL: select a from pg_roles;

2) To check duplicates in error messages.
- Open query tool
- Uncheck Auto-Commit and run below sql 3 times and you will get an error
SQL: select a from pg_roles;

3) To check proper error
SQL: --insert into pg_roles values(1);

4) To check duplicates in error messages.
SQL: insert into pg_roles values(1);

5) Tested RAISE notices from function.

6) Tested JS testcases

Please review and let me know if I missed anything.

Regards,
Murtuza

On Mon, Sep 18, 2017 at 8:20 PM, Dave Page  wrote:

> Hi
>
> On Mon, Sep 18, 2017 at 3:08 PM, Murtuza Zabuawala <
> murtuza.zabuaw...@enterprisedb.com> wrote:
>
>> Hi Dave,
>>
>> Sorry my bad, I didn't check the backend code, I assumed that it is
>> coming from psycopg2 and so I was focusing it to remove from client side :(
>>
>> PFA updated patch.
>>
>
> I think it needs to be a bit smarter than that. Whilst it works well for
> the "empty query" message, it doesn't work well for errors that have full
> details. For instance, instead of:
>
> 
> ERROR:  relation "pg_foo" does not exist
> LINE 1: select * from pg_foo
>   ^
> ** Error **
>
> ERROR: relation "pg_foo" does not exist
> SQL state: 42P01
> Character: 15
> 
>
> We now get:
>
> 
> ERROR: ERROR:  relation "pg_foo" does not exist
> LINE 1: select * from pg_foo
>   ^
>
>
> ERROR: relation "pg_foo" does not exist
> SQL state: 42P01
> Character: 15
> 
>
> ​Done​


>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
diff --git a/web/pgadmin/utils/driver/psycopg2/__init__.py 
b/web/pgadmin/utils/driver/psycopg2/__init__.py
index 11952e1..e9d312b 100644
--- a/web/pgadmin/utils/driver/psycopg2/__init__.py
+++ b/web/pgadmin/utils/driver/psycopg2/__init__.py
@@ -1537,6 +1537,22 @@ Failed to reset the connection to the server due to 
following error:
 resp.append(self.__notices.pop(0))
 return resp
 
+def decode_to_utf8(self, value):
+"""
+This method will decode values to utf-8
+Args:
+value: String to be decode
+
+Returns:
+Decoded string
+"""
+if hasattr(str, 'decode'):
+try:
+value = value.decode('utf-8')
+except:
+pass
+return value
+
 def _formatted_exception_msg(self, exception_obj, formatted_msg):
 """
 This method is used to parse the psycopg2.Error object and returns the
@@ -1548,7 +1564,6 @@ Failed to reset the connection to the server due to 
following error:
 formatted_msg: if True then function return the formatted 
exception message
 
 """
-
 if exception_obj.pgerror:
 errmsg = exception_obj.pgerror
 elif exception_obj.diag.message_detail:
@@ -1556,60 +1571,72 @@ Failed to reset the connection to the server due to 
following error:
 else:
 errmsg = str(exception_obj)
 # errmsg might contains encoded value, lets decode it
-if hasattr(str, 'decode'):
-errmsg = errmsg.decode('utf-8')
+errmsg = self.decode_to_utf8(errmsg)
 
 # if formatted_msg is false then return from the function
 if not formatted_msg:
 return errmsg
 
-errmsg += u'** Error **\n\n'
+# Do not append if error starts with `ERROR:` as most pg related
+# error starts with `ERROR:`
+if not errmsg.startswith(u'ERROR:'):
+errmsg = u'ERROR:  ' + errmsg + u'\n\n'
 
 if exception_obj.diag.severity is not None \
 and exception_obj.diag.message_primary is not None:
-errmsg += u"{}: {}".format(
+ex_diag_message = u"{0}:  {1}".format(
 exception_obj.diag.severity,
-exception_obj.diag.message_primary.decode('utf-8') if
-hasattr(str, 'decode') else exception_obj.diag.message_primary)
-
+self.decode_to_utf8(exception_obj.diag.message_primary)
+)
+# If both errors are different then only append it
+if errmsg and ex_diag_message and \
+ex_diag_message.strip().strip('\n').lower() not in \
+errmsg.strip().strip('\n').lower():
+errmsg += ex_diag_message
 elif exception_obj.diag.message_primary is not None:
-errmsg += exception_obj.diag.message_primary.decode('utf-8') if \
-hasattr(str, 'decode') else 

Re: v2.0 RC2 test builds

[Surinder Kumar]

Hi Fahar,

It gets installed successfully when I checked the option "Allow apps
downloaded from" to "Anywhere" in Security & Privacy option.
However, If I install another downloaded app, It asks the user to enable
the install for this app by going to Security & Privacy option.

Thanks to Khushboo for help.

On Tue, Sep 19, 2017 at 11:36 AM, Fahar Abbas 
wrote:

> Hi Surinder,
>
> I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue related to
> this.
>
> Steps:
> 1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on MAC
> 10.10 fresh VM.
>
> Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped this
> support.
>
> Can you please share the exact steps so it could reproduce on my fresh VM?
>
> Kind Regards,
>
>
> On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
> surinder.ku...@enterprisedb.com> wrote:
>
>> Hi
>>
>> Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
>> ) for
>> Mac but it is failed to open. When I double click on pgAdmin4 icon to open
>> pgAdmin4, I got an error, please refer the screenshot attached.
>>
>> *OS details:*
>>
>> Mac OS X Yosemite
>> Version 10.10.2
>>
>> Even on Akshay's machine pgAdmin4 doesn't open
>>
>> *OS details:*
>>
>> Mac OS X Mavericks
>> Version 10.09.05
>>
>> *Error:*
>>
>> The application server couldn't be contacted.
>>
>> @Fahar, Can you please verify If you got same error?
>>
>> Thanks,
>> Surinder
>>
>>
>> On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros 
>> wrote:
>>
>>> No show-stoppers to report. Just to say that it looks great and loads
>>> fast. Nice work!
>>>
>>> Only stylistic item is that the column names in the result grid used to
>>> be bold but are now the same weight as the data type.
>>>
>>> Anthony
>>>
>>>
>>> On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
>>> wrote:
>>>
>>> I've put v2.0-rc2 test builds at https://developer.pgadmin.o
>>> rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
>>> show-stopper issues ASAP!
>>>
>>> Devrim; these includes the WSGI fix needed for the problem I ran into
>>> when testing the RPMs in web mode.
>>>
>>> Thanks.
>>>
>>> --
>>> Dave Page
>>> Blog: http://pgsnake.blogspot.com
>>> Twitter: @pgsnake
>>>
>>> EnterpriseDB UK: http://www.enterprisedb.com
>>> The Enterprise PostgreSQL Company
>>>
>>>
>>
>
>
> --
> Fahar Abbas
> QMG
> EnterpriseDB Corporation
> Phone Office: +92-51-835-8874
> Phone Direct: +92-51-8466803
> Mobile: +92-333-5409707
> Skype ID: syed.fahar.abbas
> Website: www.enterprisedb.com
>

Re: v2.0 RC2 test builds

[Fahar Abbas]

Hi Surinder,

I tested pgAdmin4 Build on MAC 10.10 and i don't see any issue related to
this.

Steps:
1. Downloaded MAC OS Build on 10.12 Firefox Browser and then scp on MAC
10.10 fresh VM.

Note: pgAdmin4 will not work on MAC 10.9 and we have already dropped this
support.

Can you please share the exact steps so it could reproduce on my fresh VM?

Kind Regards,


On Tue, Sep 19, 2017 at 10:45 AM, Surinder Kumar <
surinder.ku...@enterprisedb.com> wrote:

> Hi
>
> Today I downloaded the pgAdmin4 build(pgadmin4-2.0-rc2.dmg
> ) for
> Mac but it is failed to open. When I double click on pgAdmin4 icon to open
> pgAdmin4, I got an error, please refer the screenshot attached.
>
> *OS details:*
>
> Mac OS X Yosemite
> Version 10.10.2
>
> Even on Akshay's machine pgAdmin4 doesn't open
>
> *OS details:*
>
> Mac OS X Mavericks
> Version 10.09.05
>
> *Error:*
>
> The application server couldn't be contacted.
>
> @Fahar, Can you please verify If you got same error?
>
> Thanks,
> Surinder
>
>
> On Tue, Sep 19, 2017 at 1:27 AM, Anthony DeBarros 
> wrote:
>
>> No show-stoppers to report. Just to say that it looks great and loads
>> fast. Nice work!
>>
>> Only stylistic item is that the column names in the result grid used to
>> be bold but are now the same weight as the data type.
>>
>> Anthony
>>
>>
>> On September 18, 2017 at 12:13:03 PM, Dave Page (dp...@pgadmin.org)
>> wrote:
>>
>> I've put v2.0-rc2 test builds at https://developer.pgadmin.o
>> rg/~dpage/2.0-rc2/ for anyone who needs them. Please report any
>> show-stopper issues ASAP!
>>
>> Devrim; these includes the WSGI fix needed for the problem I ran into
>> when testing the RPMs in web mode.
>>
>> Thanks.
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
>


-- 
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: syed.fahar.abbas
Website: www.enterprisedb.com