Re: Opening queries in new window, record caching when scrolling

On Thu, Jul 20, 2017 at 10:12 AM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > > > On Thu, Jul 20, 2017 at 9:56 AM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> >> On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer >> wrote: >> >>> Hi, >>> >>> One of the items that

Re: Opening queries in new window, record caching when scrolling

On Thu, Jul 20, 2017 at 9:56 AM, Ashesh Vashi wrote: > > On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer > wrote: > >> Hi, >> >> One of the items that was noted in the release of 1.6 was the ability to >> move queries into a new window, allowing for use on multiple screens. I >> was wondering i

Re: Opening queries in new window, record caching when scrolling

On Thu, Jul 20, 2017 at 6:36 AM, Russell Mercer wrote: > Hi, > > One of the items that was noted in the release of 1.6 was the ability to > move queries into a new window, allowing for use on multiple screens. I > was wondering if anyone has been able to make this work. I've given it a > shot,

Re: Opening queries in new window, record caching when scrolling

There is a setting you need to change to open query tool in new window. Goto: 'File' -> 'Preferences' -> 'SQL Editor' -> 'Open in new browser tab' (Set this option to True) [image: Inline image 1] Regarding loading the result at once, loading the result in chunks helps us improve the performanc

Opening queries in new window, record caching when scrolling

Hi, One of the items that was noted in the release of 1.6 was the ability to move queries into a new window, allowing for use on multiple screens. I was wondering if anyone has been able to make this work. I've given it a shot, but seem to be missing a step in the process. The one way I've se

Re: Scrolling vs. pagination

Oh that’s great news, thanks so much!  John From: Dave Page Date: Tuesday, July 18, 2017 at 11:44 PM To: John Payne Cc: pgAdmin Support Subject: Re: Scrolling vs. pagination The screenshots need updating. Iirc, we got rid of pagination before we released v1.0. The query tool is

Re: Consider default SERVER_MODE =True for pgadmin4-v1-web

On Wed, Jul 19, 2017 at 5:07 PM, Mike Surcouf wrote: > Hi Dave thanks for reply > > > > In what scenario are the web components used in desktop mode. > The core of the application (like, 97% of it) is the web code. The desktop runtime is just a python interpreter with a web browser attached, tha

RE: Consider default SERVER_MODE =True for pgadmin4-v1-web

Here is my setup script for pgadmin in server mode on Centos 7 using the docs as a base. It may or may not be useful -- #Install pgadmin yum -y install pgadmin4-v1-web yum -y install python-passlib #Create user for pgadmin useradd --create

RE: Consider default SERVER_MODE =True for pgadmin4-v1-web

Hi Dave thanks for reply In what scenario are the web components used in desktop mode. Sorry if I I keep banging on about it From: Dave Page [mailto:dp...@pgadmin.org] Sent: 19 July 2017 17:03 To: Mike Surcouf Cc: pgadmin-supp...@postgresql.org Subject: Re: Consider default SERVER_MODE =True for

Re: Consider default SERVER_MODE =True for pgadmin4-v1-web

On Wed, Jul 19, 2017 at 4:54 PM, Mike Surcouf wrote: > It would be nice if the pgadmin40v1-web package set the SERVER_MODE = True > > I can't think why you would install the web package without this but there > may be a reason? > Yes, it would break the default installation mode (desktop). The

Consider default SERVER_MODE =True for pgadmin4-v1-web

It would be nice if the pgadmin40v1-web package set the SERVER_MODE = True I can't think why you would install the web package without this but there may be a reason? Also since the setup script does different things depending on this value if you don't do it first you have to delete the config

RE: Cant browse servers after update to pgadmin 1.6 (server version)

Hi Devrim Testing as it will be used i.e. remotely via the path http://someserver/pgadmin4 would have shown up this. I hope testing methodology can be changed so that the server mode is tested too. Even having a previous setup version and running yum update would help to catch this type of stuff

Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi, On Wed, 2017-07-19 at 13:03 +, Mike Surcouf wrote: > Is dev...@gunduz.org testing these repos by > installing in the app path eg (pgadmin4) as per the docs? At some point, yes, but not fully. I do more tests on my Fedora box. Regards, -- Devrim Gündüz Enterpri

RE: New font for testing in Query Editor tool

> Menlo only applies for Macs, Consolas is the new proposed font for Windows. How are you going to tell what OS. Bear in mind the server version (which I find runs much better than desktop) only has the concept of a browser agent. I think the concept of specific font on a cross platform tool is n

RE: uninstalling pgadmin4 version 1.0

Brilliant – many thanks. From: Dave Page [mailto:dp...@pgadmin.org] Sent: 19 July 2017 14:32 To: Gillian Walker Cc: pgadmin-support@lists.postgresql.org Subject: Re: uninstalling pgadmin4 version 1.0 Hi On Wed, Jul 19, 2017 at 1:37 PM, Gillian Walker wrote: Hi I have pgAdmin4 versio

Re: New font for testing in Query Editor tool

Thanks for the feedback everyone On Wed, Jul 19, 2017 at 8:18 AM matshyeq wrote: > Just a thought, if v4 is web based - why don't you use webfonts, like > whatever is available on https://fonts.google.com/?category=Monospace > with the option to fall back to the old ones? > Also, could this be e

Cant browse servers after update to pgadmin 1.6 (server version)

A have the same issue after update to 1.6, pgadmin is under apache web server. The console developer browser throws 404 on these resources because may site is under pgadmin directory not on the server root: http://dev.pgpadmin/preferences/get_all http://dev.pgpadmin/browser/nodes/ htt

Re: uninstalling pgadmin4 version 1.0

Hi On Wed, Jul 19, 2017 at 1:37 PM, Gillian Walker wrote: > Hi > > I have pgAdmin4 version 1.0 running on a windows 7 machine – I would like > to uninstall it and put on the latest version. It is installed in > C:\Program Files\PostgreSQL\9.6\pgAdmin4 – I can find no uninstall exe > within the

uninstalling pgadmin4 version 1.0

Hi I have pgAdmin4 version 1.0 running on a windows 7 machine - I would like to uninstall it and put on the latest version. It is installed in C:\Program Files\PostgreSQL\9.6\pgAdmin4 - I can find no uninstall exe within the pgAdmin4 folder and the program is not listed in the 'Uninstall or chang

RE: Cant browse servers after update to pgadmin 1.6 (server version)

It’s all to do with paths far as I can see. Its likely DESKTOP works because the default path is the root of the webserver. And as that bug report states if I run the app in the root of my site I guess it will work. It seems 1.6 is broken out the box which recommends pgadmin4 as the app path. Pre

Re: Cant browse servers after update to pgadmin 1.6 (server version)

On Wed, Jul 19, 2017 at 6:16 PM, Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala enterprisedb.com> wrote: > >> Okay, I think this is a bug with 1.6. >> >> Found similar issue: https://redmine.postgresql.org/issues/2563 >> >> > So, as p

Re: Cant browse servers after update to pgadmin 1.6 (server version)

On Wed, Jul 19, 2017 at 6:10 PM, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Okay, I think this is a bug with 1.6. > > Found similar issue: https://redmine.postgresql.org/issues/2563 > > So, as per this RM information, you can change the WSGIScriptAlias from */pgadmin4* to */*

Re: Cant browse servers after update to pgadmin 1.6 (server version)

Okay, I think this is a bug with 1.6. Found similar issue: https://redmine.postgresql.org/issues/2563 -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Jul 19, 2017 at 6:03 PM, Mike Surcouf wrote: > Still the same > > > > Tested

RE: Cant browse servers after update to pgadmin 1.6 (server version)

Still the same Tested in IE 11 and CHrome Am I picking up a early webpack preview from the repo? All I did was a yum update It seems there paths for require are not correct (missing a level pgadm4) From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com] Sent: 19 July 2017 13:27 T

Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you clear the browser cache with hard reset and try again? [image: Inline image 1] -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Jul 19, 2017 at 5:48 PM, Mike Surcouf wrote: > wcDocker.min.js:42 exported wcDocker > > jquer

RE: Cant browse servers after update to pgadmin 1.6 (server version)

In addition by pgadmin site is at http://aesdata01/pgadmin4/ So an HTTP GET to http://aesdata01/preferences/get_all will obviously fail From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com] Sent: 19 July 2017 13:14 To: Mike Surcouf Cc: pgadmin-supp...@postgresql.org Subject: Re

pgadmin4 1.6 (python wheel) doesn't work under Ubuntu Server 16.04 LTS

Hi everybody, pgadmin4 1.6 (python wheel) doesn't work under Ubuntu Server 16.04 LTS. We have installed pgadmin as usual (pgadmin4 1.5 works) but the new version 1.6 produces following web-error. /Internal Server Error The server encountered an internal error or misconfiguration and was unable to

RE: Cant browse servers after update to pgadmin 1.6 (server version)

wcDocker.min.js:42 exported wcDocker jquery-1.11.2.min.js:4 GET http://aesdata01/preferences/get_all 404 (Not Found) send @ jquery-1.11.2.min.js:4 ajax @ jquery-1.11.2.min.js:4 cache_preferences @ browser.js:953 init @ browser.js:357 (anonymous) @ (index):280 execCb @ require.min.js:29 check @ requ

Re: New font for testing in Query Editor tool

Just a thought, if v4 is web based - why don't you use webfonts, like whatever is available on https://fonts.google.com/?category=Monospace with the option to fall back to the old ones? Also, could this be easily configurable? On 19 July 2017 at 14:14, Dave Page wrote: > Possibly not, but then i

Re: New font for testing in Query Editor tool

Possibly not, but then it will fall back to the old one. On Wed, Jul 19, 2017 at 1:13 PM, Mike Surcouf wrote: > Is that font available on all browsers iPad etc? > > > > *From:* Dave Page [mailto:dp...@pgadmin.org] > *Sent:* 19 July 2017 13:11 > *To:* matshyeq > *Cc:* Mike Surcouf; Anthony DeBarr

Re: Cant browse servers after update to pgadmin 1.6 (server version)

Can you please open browser developer tool and check the Console tab if there is any error on console when you load the page? -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, Jul 19, 2017 at

RE: New font for testing in Query Editor tool

Is that font available on all browsers iPad etc? From: Dave Page [mailto:dp...@pgadmin.org] Sent: 19 July 2017 13:11 To: matshyeq Cc: Mike Surcouf; Anthony DeBarros; pgAdmin Support; Shirley Wang Subject: Re: New font for testing in Query Editor tool Monospace, which we currently use, and Menlo,

Re: New font for testing in Query Editor tool

Monospace, which we currently use, and Menlo, the proposed new default. On Wed, Jul 19, 2017 at 12:58 PM, matshyeq wrote: > What are the options? > > On 19 July 2017 at 10:37, Dave Page wrote: > >> >> >> On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf >> wrote: >> >>> Maybe I’m missing something

RE: Cant browse servers after update to pgadmin 1.6 (server version)

BTW I disabled upgrade check UPGRADE_CHECK_ENABLED = False in config.py The URLError: error is now gone but I still have no nodes in my browser pane and the add a server link doesn’t work Thanks Mike From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com] Sent: 19 July 2017 1

Re: Cant browse servers after update to pgadmin 1.6 (server version)

Are you running pgAdmin4 on Apache or any other server? (If so then can you try restarting your apache or respective web server service as well) On Wed, Jul 19, 2017 at 5:25 PM, Mike Surcouf wrote: > Same thing. > > > > In the end I deleted everything in > > > > /var/pgadmin/.pgadmin > > > > t

Re: New font for testing in Query Editor tool

What are the options? On 19 July 2017 at 10:37, Dave Page wrote: > > > On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf wrote: > >> Maybe I’m missing something, >> >> >> >> Shouldn’t all code including SQL use fixed width font? >> > > It does. The question is, *which* fixed width font. > > >> >> >

RE: Cant browse servers after update to pgadmin 1.6 (server version)

Same thing. In the end I deleted everything in /var/pgadmin/.pgadmin then ran su -s /bin/sh -c 'python /usr/lib/python2.7/site-packages/pgadmin4-web/setup.py' pgadmin Still no nodes in the browser pane From: Murtuza Zabuawala [mailto:murtuza.zabuaw...@enterprisedb.com] Sent: 19 July 2017 12:

Re: Cant browse servers after update to pgadmin 1.6 (server version)

Hi, It looks like you pgAdmin4 configuration file got corrupted. Can you rename your pgAdmin4 configuration file and try to start pgAdmin4 again? mv ~/.pgadmin/pgadmin4.db ~/.pgadmin/pgadmin4.db_old -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQ

Re: New font for testing in Query Editor tool

On Wed, Jul 19, 2017 at 9:34 AM, Mike Surcouf wrote: > Maybe I’m missing something, > > > > Shouldn’t all code including SQL use fixed width font? > It does. The question is, *which* fixed width font. > > > *From:* Dave Page [mailto:dp...@pgadmin.org] > *Sent:* 19 July 2017 09:00 > *To:* Antho

RE: New font for testing in Query Editor tool

Maybe I’m missing something, Shouldn’t all code including SQL use fixed width font? From: Dave Page [mailto:dp...@pgadmin.org] Sent: 19 July 2017 09:00 To: Anthony DeBarros Cc: pgAdmin Support; Shirley Wang Subject: Re: New font for testing in Query Editor tool On Wed, Jul 19, 2017 at 1:33 AM,

Re: pgAdmin 4 v1.6 Released!

pts rule name description -- -- -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay domain 2.5 BAYES_50

Re: pgAdmin 4 v1.6 Released!

[Narrowing the addressee list] Hi On Tue, Jul 18, 2017 at 11:14 PM, Pawel Hadam wrote: > Hi Dave, > > Thank you for this advise. > > Please find attached my files: > > 1) C:\Users\pawelhadam\AppData\Roaming\pgAdmin\pgadmin4.log > > I cannot understand why this log file says "Starting pgAdmin 4

Re: New font for testing in Query Editor tool

On Wed, Jul 19, 2017 at 1:33 AM, Anthony DeBarros wrote: > I like it! I agree with the earlier poster that the line height could be > decreased -- but not by much. Perhaps a pixel or two. > Yeah, something was bugging me about it too - I think it was the line height. > > Anthony > > > > > Hell