Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-15 Thread Mike Surcouf
e big improvements. From: Patrick Headley [mailto:phead...@linxco-inc.com] Sent: 14 June 2017 16:57 To: Mike Surcouf; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] "pgadmin4" - slow? It used to take longer. Now, after starting up the times are comparable to pgAdmin3. Patri

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Patrick Headley
is encouraging? *From:*pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] *On Behalf Of *Patrick Headley *Sent:* 14 June 2017 01:23 *To:* pgadmin-support@postgresql.org *Subject:* Re: [pgadmin-support] "pgadmin4" - slow? While I still wish pgAdmin4

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
whatwg.org/. look like your loading something via ajax with async:false -Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: 14 June 2017 14:44 To: Mike Surcouf Cc: Bruno Friedmann; pgAdmin Support Subject: Re: [pgadmin-support] "pgadmin4" - slow? On Wed, Jun 14, 2

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
> https://xhr.spec.whatwg.org/. > > look like your loading something via ajax with async:false Yeah, that one is on my TODO to fix. > > > -Original Message- > From: Dave Page [mailto:dp...@pgadmin.org] > Sent: 14 June 2017 14:44 > To: Mike Surcouf > Cc: Bruno Friedm

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
] On Behalf Of Dave Page Sent: 14 June 2017 14:17 To: Bruno Friedmann Cc: pgAdmin Support Subject: Re: [pgadmin-support] "pgadmin4" - slow? On Wed, Jun 14, 2017 at 1:55 PM, Bruno Friedmann wrote: > On mercredi, 14 juin 2017 10.13:44 h CEST Dave Page wrote: >> On Wed, Jun 14, 20

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
-slow-remote-page-load-performance-in-qtwebkit-windows > > -Original Message- > From: pgadmin-support-ow...@postgresql.org > [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Dave Page > Sent: 14 June 2017 14:17 > To: Bruno Friedmann > Cc: pgAdmin Support > Su

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 2:28 PM, Melvin Davidson wrote: > *Regardless of the upcoming problem resolution regarding slow start times, > or any of the multitude of Reddit reports, I think PgAdmin developers > should consider this a lesson learned and test on ALL platforms (IE:Mac, > Windows, Linux)

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Melvin Davidson
Regardless of the upcoming problem resolution regarding slow start times, or any of the multitude of Reddit reports, I think PgAdmin developers should consider this a lesson learned and test on ALL platforms (IE:Mac, Windows, Linux) before releasing a new version.  Melvin Davidson 🎸     Cell

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 1:55 PM, Bruno Friedmann wrote: > On mercredi, 14 juin 2017 10.13:44 h CEST Dave Page wrote: >> On Wed, Jun 14, 2017 at 9:07 AM, Mike Surcouf wrote: >> > Static resources will be good for caching :-) I would expect to see >> > performance gains when using remotely via a b

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Bruno Friedmann
On mercredi, 14 juin 2017 10.13:44 h CEST Dave Page wrote: > On Wed, Jun 14, 2017 at 9:07 AM, Mike Surcouf wrote: > > Static resources will be good for caching :-) I would expect to see > > performance gains when using remotely via a browser. Thankyou. I'm not > > sure whether QtWeb will benefit

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread David Lloyd
13 June 2017 8:23 PM To: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] "pgadmin4" - slow? While I still wish pgAdmin4 was faster to start up I installed pgAdmin4 v1.5 today and performed some tests. Here's what I found. The test machine is a Windows 7 VirtualBox VM. The

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
which case I hope it helps. -Original Message- From: Dave Page [mailto:dp...@pgadmin.org] Sent: 14 June 2017 08:56 To: Mike Surcouf Cc: Patrick Headley; pgadmin-support@postgresql.org Subject: Re: [pgadmin-support] "pgadmin4" - slow? On Wed, Jun 14, 2017 at 8:29 AM, Mike Surcouf

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 9:07 AM, Mike Surcouf wrote: > Static resources will be good for caching :-) I would expect to see > performance gains when using remotely via a browser. Thankyou. > I'm not sure whether QtWeb will benefit as much as its local traffic so round > trips should be pretty i

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Dave Page
On Wed, Jun 14, 2017 at 8:29 AM, Mike Surcouf wrote: > A 32 second startup time and a 2-6 seconds to expand each node is > encouraging? Unless you're on a slow connection, the node expansion time should be extremely quick the second and subsequent times in a session, and even then the delay shou

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-14 Thread Mike Surcouf
A 32 second startup time and a 2-6 seconds to expand each node is encouraging? From: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Patrick Headley Sent: 14 June 2017 01:23 To: pgadmin-support@postgresql.org Subject: Re: [pgadmin-support

Re: [pgadmin-support] "pgadmin4" - slow?

2017-06-13 Thread Patrick Headley
While I still wish pgAdmin4 was faster to start up I installed pgAdmin4 v1.5 today and performed some tests. Here's what I found. The test machine is a Windows 7 VirtualBox VM. The host has a 4GHz processor and an SSD. The host network connection uses an AC 1200 WiFi card. I believe I'm testin

[pgadmin-support] "pgadmin4" - slow?

2017-06-13 Thread David Lloyd
Is it just me or is "pgadmin4" just terribly slow? I'm running it on a capable HP Laptop (it runs Postgres itself very well) but "pgadmin4" seems impossibly slow. Connecting to my Postgres from the local machine doesn't seem to be the bottleneck (I have a Laravel application that runs ju

[pgadmin-support] pgadmin4: "The application server could not be contacted."

2017-06-02 Thread petrov.bori...@mail.ru
Hi. An attempt to start pgadmin4 yelds message box with "The application server could not be contacted." error. Is there any logs or something I can check? Name: pgadmin4-v1 Arch: x86_64 Version : 1.5 Release : 2.f25 Repo: @System From repo : pgdg96 Linux 4.

Re: [pgadmin-support] pgAdmin4 and boolean columns

2017-05-30 Thread Surinder Kumar
Hi Nigel, ​Already a similar issue RM2218 logged which is resolved. Also, which version of pgAdmin4 you are using ? On Wed, May 31, 2017 at 3:00 AM, Nigel Tucker < ni...@specialisedstructures.co.nz> wrote: > Hi, > > > > pgAdmin4 has difficulty with s

Re: [pgadmin-support] pgAdmin4 and boolean columns

2017-05-30 Thread Surinder Kumar
Hi Nigel, Please log the issue here so that it can be tracked. https://redmine.postgresql.org/projects/pgadmin4 Thanks Surinder On Wed, May 31, 2017 at 3:00 AM, Nigel Tucker < ni...@specialisedstructures.co.nz> wrote: > Hi, > > > > pgAdmin4 has

[pgadmin-support] pgAdmin4 and boolean columns

2017-05-30 Thread Nigel Tucker
Hi, pgAdmin4 has difficulty with setting or changing Boolean check boxes in Windows 10. Double clicking on a Boolean cell initially null converts the display to an empty box, which on leaving that cell displays 'false'. If you return to the box and click once on it, it switches to a ticked

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Shira Bezalel
gt; >> I just changed from Windows desktop to SERVER_MODE with apache and > it > >> >> is > >> >> completely different app. > >> >> > >> >> So much faster. Looks like there is something seriously wrong with > the > >> >

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
aster. Looks like there is something seriously wrong with the >> >> Qt implementation. >> >> >> >> Plus I only have to install it once. >> >> >> >> It’s a pain to setup in server mode though. >> >> >> >> >> >> &

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Shira Bezalel
>> > >> Plus I only have to install it once. > >> > >> It’s a pain to setup in server mode though. > >> > >> > >> > >> From: pgadmin-support-ow...@postgresql.org > >> [mailto:pgadmin-support-ow...@postgresql.org] On Behalf

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Dave Page
ostgresql.org >> [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Richard Greenwood >> Sent: 24 May 2017 14:15 >> To: pgadmin-support@postgresql.org >> Subject: [pgadmin-support] pgAdmin4 speed >> >> >> >> There were several recent comment

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Richard Greenwood
> pgadmin-support-ow...@postgresql.org] *On Behalf Of *Richard Greenwood > *Sent:* 24 May 2017 14:15 > *To:* pgadmin-support@postgresql.org > *Subject:* [pgadmin-support] pgAdmin4 speed > > > > There were several recent comments on this list about pgAdmin4 being slow >

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Shira Bezalel
ve to install it once. > > It’s a pain to setup in server mode though. > > > > *From:* pgadmin-support-ow...@postgresql.org [mailto: > pgadmin-support-ow...@postgresql.org] *On Behalf Of *Richard Greenwood > *Sent:* 24 May 2017 14:15 > *To:* pgadmin-support@postgresql.o

Re: [pgadmin-support] pgAdmin4 speed

2017-05-25 Thread Mike Surcouf
-ow...@postgresql.org [mailto:pgadmin-support-ow...@postgresql.org] On Behalf Of Richard Greenwood Sent: 24 May 2017 14:15 To: pgadmin-support@postgresql.org Subject: [pgadmin-support] pgAdmin4 speed There were several recent comments on this list about pgAdmin4 being slow which surprised me as

Re: [pgadmin-support] pgAdmin4 speed

2017-05-24 Thread Melvin Davidson
kalley.com From: Richard Greenwood To: pgadmin-support@postgresql.org Sent: Wednesday, May 24, 2017 9:15 AM Subject: [pgadmin-support] pgAdmin4 speed There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdm

[pgadmin-support] pgAdmin4 speed

2017-05-24 Thread Richard Greenwood
There were several recent comments on this list about pgAdmin4 being slow which surprised me as I've found it to be faster than pgAdmin3. But then I saw pgAdmin4 on a Windows machine in standalone mode and realized what people are complaining about. I'm running the python server script and then us

Re: [pgadmin-support] PgAdmin4 problem with connect

2017-05-10 Thread Walter Willmertinger
Ok, thanks. I just noticed it in the documentation. So I must use PgAdmin3 fro some more time! Murtuza Zabuawala schrieb am Mi., 10. Mai 2017 um 11:33 Uhr: > pgAdmin4 supports Postgres 9.2 and above versions. > > -- > Regards, > Murtuza Zabuawala > EnterpriseDB: http://www.enterprisedb.com > Th

Re: [pgadmin-support] PgAdmin4 problem with connect

2017-05-10 Thread Murtuza Zabuawala
pgAdmin4 supports Postgres 9.2 and above versions. -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Wed, May 10, 2017 at 2:56 PM, Walter Willmertinger wrote: > I just tried to use the actual Pgadmin4. Version info is: > ***

[pgadmin-support] PgAdmin4 problem with connect

2017-05-10 Thread Walter Willmertinger
I just tried to use the actual Pgadmin4. Version info is: *** Version1.4 CopyrightCopyright 2013 - 2017, The pgAdmin Development Team Python Version2.7.12 (v2.7.12:d33e0cf91556, Jun 27 2016, 15:19:22) [MSC v.1500 32 bit (Intel)] Flask Version0.11.1 Application ModeDesktop Curren

Re: [pgadmin-support] pgadmin4 login page

2017-05-08 Thread Khushboo Vashi
Hi, pgAdmin 4 can be deployed in 2 ways. - Desktop Runtime (as per your email, you are using this mode), which is single user mode. - Web application, through which you can configure users profile. Please go through the documentation https://www.pgadmin.org/docs4/1.x/getting_started.html to con

Re: [pgadmin-support] pgadmin4 login page

2017-05-08 Thread Peter S. Shenkin
​I'm a newbie at DB admin and have been trying to understand similar issues. So the following might not be completely right; but hopefully it's a step in the right direction and someone with more experience can amplify or correct. My sense is that what PostgreSQL expects you to do is to GRANT perm

[pgadmin-support] pgadmin4 login page

2017-05-08 Thread Brent Vaughn
Is there way to setup a login page for pgadmin4? I am not seeing how to do this. Currently, if a user goes to the URL they aren't required to authenticate to use pgadmin4. If someone adds a database and saves the password, then any user with the URL to pgadmin4 can manipulate that database.

Re: [pgadmin-support] pgadmin4-1.4

2017-04-19 Thread Dave Page
Awesome! Thank you for the feedback and bearing with us. On Wed, Apr 19, 2017 at 2:42 PM, Campbell, Lance wrote: > I have a Windows 7 64 desktop. I just installed pgadmin 4-1.4 . I am very > impressed. I was having a lot of issues with the prior releases of 4-1.2 > and 4-1.3. These issues hav

[pgadmin-support] pgadmin4-1.4

2017-04-19 Thread Campbell, Lance
I have a Windows 7 64 desktop. I just installed pgadmin 4-1.4 . I am very impressed. I was having a lot of issues with the prior releases of 4-1.2 and 4-1.3. These issues have disappeared. You did a great job getting the installation issues addressed. Thanks for the hard work. Lance Campb

[pgadmin-support] pgadmin4 crash on windows 7

2017-04-18 Thread CHERAT Francis
Hello, I want to see all rows of my table with this sql query on pgadmin4 v1.4 on my PC with windows 7. Select * from public.fil this table as 93 rows, the table size is 79Mo the ddl is CREATE TABLE public.fil ( identifiant integer NOT NULL, numero integer NOT NULL, numeroreg

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-05 Thread Dave Page
On Tue, Apr 4, 2017 at 11:36 PM, rhuddbiz wrote: > Dave, > > after installing > https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.3/pip/pgadmin4-1.3-py2.py3-none-any.whl > > i can't seem to find any filename matching the one you mentioned, that seems > strange to me. > web/pgadmin/__init__.py T

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-05 Thread rhuddbiz
Dave, after installing https://ftp.postgresql.org/pub/pgadmin3/pgadmin4/v1.3/pip/pgadmin4-1.3-py2.py3-none-any.whl i can't seem to find any filename matching the one you mentioned, that seems strange to me. web/pgadmin/__init__.py -- View this message in context: http://www.postgresql-archiv

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-04 Thread jbiskofski
this is how I got it to work : VHOST FILE == *server {* *listen *:443 ssl;* *server_name pg.YOURDOMAIN.com ;* * include /usr/local/nginx/conf/ssl.conf;* * include /usr/local/nginx/conf/proxies.conf;* * location / {* * proxy_pass http://pgad

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-04 Thread Dave Page
On Tue, Apr 4, 2017 at 12:19 AM, rhuddbiz wrote: > well, setting APPLICATION_ROOT did not work. i know i have the > config_local.py setup correctly because i am able to configure > DEFAULT_SERVER. i think i see where you came up with APPLICATION_ROOT param, > http://flask.pocoo.org/docs/0.12/confi

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-04 Thread rhuddbiz
well, setting APPLICATION_ROOT did not work. i know i have the config_local.py setup correctly because i am able to configure DEFAULT_SERVER. i think i see where you came up with APPLICATION_ROOT param, http://flask.pocoo.org/docs/0.12/config/. unfortunately, it looks like pgAdmin4.py does not mak

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread Dave Page
On Mon, Apr 3, 2017 at 2:30 PM, rhuddbiz wrote: > i don't think knowing nginx is the key to this. it's more of a general > question for any proxy setup that uses python to run pgadmin4. we are > launching pgadmin4 on localhost:5050, with a systemd file containing > /usr/bin/python3.5 > /usr/loca

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread rhuddbiz
i don't think knowing nginx is the key to this. it's more of a general question for any proxy setup that uses python to run pgadmin4. we are launching pgadmin4 on localhost:5050, with a systemd file containing /usr/bin/python3.5 /usr/local/lib/python3.5/dist-packages/pgadmin4/pgAdmin4.py is ther

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread Dave Page
On Sun, Apr 2, 2017 at 9:00 PM, rhuddbiz wrote: > how can i specify a path for the python application behind nginx ? we want > to enable security with our existing ssl cert . we have https://foo.com/ > and we want to forward https://foo.com/pgadmin/ to our python wrapper around > pgadmin4. unfo

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-04-03 Thread rhuddbiz
how can i specify a path for the python application behind nginx ? we want to enable security with our existing ssl cert . we have https://foo.com/ and we want to forward https://foo.com/pgadmin/ to our python wrapper around pgadmin4. unfortunately, the naive approach does not work as the href l

Re: [pgadmin-support] PgAdmin4 Bug report - Zoomed too far out

2017-03-30 Thread gloreo411
I was able to zoom back in with this shortcut key combination: shift + command + "+" To zoom out: command + "+" macOS Sierra version: 10.12.3 pgAdmin 4 version: 1.3 -- View this message in context: http://www.postgresql-archive.org/PgAdmin4-Bug-report-Zoomed-too-far-out-tp5926867p5953091.html

Re: [pgadmin-support] pgadmin4 sig?

2017-03-21 Thread Dave Page
Hi On Tue, Mar 21, 2017 at 3:01 PM, Ray Stell wrote: > Sorry, what's the problem here? Have you changed your gpg key? > > $ gpg --recv 698F1519 > gpg: requesting key 698F1519 from hkp server keyserver.cns.vt.edu > gpg: key 698F1519: "Dave Page " not changed > gpg: key 698F1519: "Dave Page " not

[pgadmin-support] pgadmin4 sig?

2017-03-21 Thread Ray Stell
Sorry, what's the problem here? Have you changed your gpg key? $ gpg --recv 698F1519 gpg: requesting key 698F1519 from hkp server keyserver.cns.vt.edu gpg: key 698F1519: "Dave Page " not changed gpg: key 698F1519: "Dave Page " not changed gpg: Total number processed: 2 gpg: unchanged

[pgadmin-support] pgAdmin4 runtime error: linux

2017-03-10 Thread Rich Shepard
Built pgAdmin4 following the README runtime instructions and copied pgAdmin4 and pgAdmin4.py to /usr/local/bin. When invoked the splash screen displays and is immediately overlaid with an error message: "An error occurred initializing the application server: Failed to launch the application

[pgadmin-support] pgadmin4:1.2 Apache HTTPD/uWsgi issue

2017-02-24 Thread jlundberg
We have uwsgi/pgadmin running in a Docker container. Apache HTTPD runs on the host machine and proxies requests to uwsgi. For small queries with small return data sets, everything works great. However, on larger queries with large return data sets we have issues: httpd-2.4.6-45 uWSGI==2.0.14

Re: [pgadmin-support] PgAdmin4 Dmode save layouts

2017-02-20 Thread Dave Page
Hi On Sun, Feb 19, 2017 at 8:33 AM, Alexey B. wrote: > Hello all. > > I've configured PgAdmin4 to work in the Desktop mode. > All ok for now except one thing. > > When you quit PgAdmin4, does the tree layout save - and remember for next > time you reopen - in pgAdmin3, there is file>quit menu opt

[pgadmin-support] PgAdmin4 Dmode save layouts

2017-02-19 Thread Alexey B.
Hello all. I've configured PgAdmin4 to work in the Desktop mode. All ok for now except one thing. When you quit PgAdmin4, does the tree layout save - and remember for next time you reopen - in pgAdmin3, there is file>quit menu option, which saves session. In pgAmin4, I can’t see quit option...

[pgadmin-support] pgadmin4 1.2 RPMs are now available

2017-02-18 Thread Devrim Gündüz
Hi, Thanks to Dave, pgAdmin4 1.2 RPMs are now ready on RHEL/CentOS 7 and Fedora 24 and 25. We have RPMs back to PostgreSQL 9.4 at this point. Please install them with: {yum,dnf} -y install pgadmin4-v1 if you are already using PostgreSQL YUM repo. If not, please visit this page for more details.

Re: [pgadmin-support] pgAdmin4 and Archlinux

2017-02-15 Thread A.J.L.R. Hasekamp
Hello Dave, Indeed, pgAdmin4 version 1.2 runs fine. Thank you, Andre Hasekamp. Dave Page wrote: On Sun, Feb 5, 2017 at 4:22 PM, A.J.L.R. Hasekamp wrote: We Archlinux people are special

Re: [pgadmin-support] pgAdmin4 and Archlinux

2017-02-14 Thread Dave Page
On Sun, Feb 5, 2017 at 4:22 PM, A.J.L.R. Hasekamp wrote: > We Archlinux people are special. We always have the latest "bleeding-edge" > packages, but with them also the latest errors in our packages. > > There was a time when pgAdmin4 version 1.1 ran in my environment. pgAdmin4 > is not (yet?) in

Re: [pgadmin-support] pgAdmin4 - Fetching Type Error

2017-02-06 Thread Murtuza Zabuawala
What's your PostgreSQL version? -- Regards, Murtuza Zabuawala EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Mon, Feb 6, 2017 at 7:29 PM, Rodrigo de Lima Vieira < rodrigo.surfmercha...@gmail.com> wrote: > I'm running pgAdmin4v1.1 (server version) on top of CentOS

[pgadmin-support] pgAdmin4 - Fetching Type Error

2017-02-06 Thread Rodrigo de Lima Vieira
I'm running pgAdmin4v1.1 (server version) on top of CentOS 6.8 Version1.1 CopyrightCopyright 2013 - 2016, The pgAdmin Development Team Python Version2.6.6 (r266:84292, Aug 18 2016, 15:13:37) [GCC 4.4.7 20120313 (Red Hat 4.4.7-17)] Flask Version0.11.1 Application ModeServer Current usersyst...@surf

[pgadmin-support] pgAdmin4 and Archlinux

2017-02-05 Thread A.J.L.R. Hasekamp
We Archlinux people are special. We always have the latest "bleeding-edge" packages, but with them also the latest errors in our packages. There was a time when pgAdmin4 version 1.1 ran in my environment. pgAdmin4 is not (yet?) in the offi

[pgadmin-support] pgAdmin4 not displaying geometry details nicely (for a GIS table)

2017-02-01 Thread Ronnie Taib
Hi all, I'm a newbie here, so I hope this message is relevant to this forum. I posted it in gis.stackexchange (http://gis.stackexchange.com/q/226578/90727), but I guess it belongs to the pgAdmin4 developers, really. Basically, there is a difference of behaviour between pgAdminIII and pgAdmin4

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dan Davis
Another trick here is to let the back-end know that it is https: proxy_set_header X-Forwarded-Proto https; On Wed, Feb 1, 2017 at 12:34 PM, jbiskofski wrote: > I Set up my nginx as Harshal suggested and this fixed the problem. Thanks > for the help! > > On Wed, Feb 1, 2017 at 3:37 AM, Dave Pag

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread jbiskofski
I Set up my nginx as Harshal suggested and this fixed the problem. Thanks for the help! On Wed, Feb 1, 2017 at 3:37 AM, Dave Page wrote: > > > On Wed, Feb 1, 2017 at 10:20 AM, Ashesh Vashi < > ashesh.va...@enterprisedb.com> wrote: > >> On Wed, Feb 1, 2017 at 3:44 PM, Dave Page wrote: >> >>> On

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dave Page
On Wed, Feb 1, 2017 at 10:20 AM, Ashesh Vashi wrote: > On Wed, Feb 1, 2017 at 3:44 PM, Dave Page wrote: > >> On Wed, Feb 1, 2017 at 10:11 AM, Harshal Dhumal >> wrote: >> > Hi, >> > >> > When I setup my machine with below server setup and without >> proxy_redirect I >> > got slightly different b

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Ashesh Vashi
On Wed, Feb 1, 2017 at 3:44 PM, Dave Page wrote: > On Wed, Feb 1, 2017 at 10:11 AM, Harshal Dhumal > wrote: > > Hi, > > > > When I setup my machine with below server setup and without > proxy_redirect I > > got slightly different behaviour. In my case all redirects were failing > > cause browser

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Dave Page
On Wed, Feb 1, 2017 at 10:11 AM, Harshal Dhumal wrote: > Hi, > > When I setup my machine with below server setup and without proxy_redirect I > got slightly different behaviour. In my case all redirects were failing > cause browser was redirecting all request to http while server (nginx) was > con

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-02-01 Thread Harshal Dhumal
Hi, When I setup my machine with below server setup and without proxy_redirect I got slightly different behaviour. In my case all redirects were failing cause browser was redirecting all request to http while server (nginx) was configure to serve only https. I didn't get any intermittent state lik

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-01-30 Thread Harshal Dhumal
-- *Harshal Dhumal* *Software Engineer* EnterpriseDB India: http://www.enterprisedb.com The Enterprise PostgreSQL Company On Mon, Jan 30, 2017 at 3:33 PM, Dave Page wrote: > Hi > > On Sun, Jan 29, 2017 at 7:33 PM, jbiskofski wrote: > > Hello everyone, > > > > I have installed pgadmin4 on apac

Re: [pgadmin-support] pgadmin4 running behind nginx

2017-01-30 Thread Dave Page
Hi On Sun, Jan 29, 2017 at 7:33 PM, jbiskofski wrote: > Hello everyone, > > I have installed pgadmin4 on apache 2.2 with mod_wsgi, and it seems to be > working correctly. > > The problem is I need to run nginx in front of it to enable https and > caching. When I try to access pgadmin with this se

[pgadmin-support] pgadmin4 running behind nginx

2017-01-29 Thread jbiskofski
Hello everyone, I have installed pgadmin4 on apache 2.2 with mod_wsgi, and it seems to be working correctly. The problem is I need to run nginx in front of it to enable https and caching. When I try to access pgadmin with this setup I get errors in the browser about some elements not being able t

[pgadmin-support] pgadmin4 - Allow re-opening queries from the history

2017-01-24 Thread Mark Murawski
Say you have a tab: Query-1 open You go to history, and say you have some failed queries you want to retry The full query is truncated in the 'Query' column and there's no options to re-open this query and try again (or edit) -- Sent via pgadmin-support mailing list (pgadmin-support@postgre

[pgadmin-support] pgadmin4 - Don't disable save button after failure while editing table

2017-01-24 Thread Mark Murawski
1) While doing Table -> View Data, and inserting a new row: If you get an error such as a primary key violation on a table that uses a serial... you may have violation where id=1... and you may want to retry because you know that id=2 is available... so the counter will increase and your inser

Re: [pgadmin-support] PgAdmin4 crashing on Windows 10

2017-01-05 Thread Shira Bezalel
On Thu, Jan 5, 2017 at 1:17 AM, Dave Page wrote: > On Thu, Jan 5, 2017 at 12:03 AM, Shira Bezalel wrote: > > > > On Fri, Dec 23, 2016 at 2:31 PM, Shira Bezalel wrote: > >> > >> Hello, > >> > >> I installed the PgAdmin4 Version1.1 client yesterday on my Windows 10 > >> machine. It is connecting

Re: [pgadmin-support] PgAdmin4 crashing on Windows 10

2017-01-05 Thread Dave Page
On Thu, Jan 5, 2017 at 12:03 AM, Shira Bezalel wrote: > > On Fri, Dec 23, 2016 at 2:31 PM, Shira Bezalel wrote: >> >> Hello, >> >> I installed the PgAdmin4 Version1.1 client yesterday on my Windows 10 >> machine. It is connecting to a single 9.6.1 Postgres server on a remote >> machine. In the la

Re: [pgadmin-support] PgAdmin4 crashing on Windows 10

2017-01-04 Thread Shira Bezalel
On Fri, Dec 23, 2016 at 2:31 PM, Shira Bezalel wrote: > Hello, > > I installed the PgAdmin4 Version1.1 client yesterday on my Windows 10 > machine. It is connecting to a single 9.6.1 Postgres server on a remote > machine. In the last 24 hours, the client has shutdown unexpectedly three > times wi

[pgadmin-support] PgAdmin4 crashing on Windows 10

2016-12-23 Thread Shira Bezalel
Hello, I installed the PgAdmin4 Version1.1 client yesterday on my Windows 10 machine. It is connecting to a single 9.6.1 Postgres server on a remote machine. In the last 24 hours, the client has shutdown unexpectedly three times with the message 'PgAdmin stopped working'. The latter two times, I w

[pgadmin-support] pgadmin4 import csv issue

2016-12-21 Thread Huston Bokinsky
Hi all, Using pgadmin v. 4.1.1 on a Mac laptop (Sierra), connected to a remote postgres db v. 9.5.5. I am trying to import csv data into the db using the import/export tool. I am importing data from a file on my laptop, so browse to the csv file in the 'Filename' bar. The import fails with a mes

Re: [pgadmin-support] pgadmin4 edit function properties resets arguments

2016-12-20 Thread Khushboo Vashi
Hi, The similar issue is already reported #1979 . The issue has been fixed and it will be available in the next release. Thanks, Khushboo On Tue, Dec 20, 2016 at 2:07 PM, Vladimir Yavoskiy wrote: > Hi! > > using pgAdmin4 1.1 I can't edit my functio

[pgadmin-support] pgadmin4 edit function properties resets arguments

2016-12-20 Thread Vladimir Yavoskiy
Hi! using pgAdmin4 1.1 I can't edit my functions: 1. create function with arguments 2. refresh scheme 3. edit function properties - there is no arguments in tab 4. edit function code - there is no arguments in SQL tab: "CREATE OR REPLACE FUNCTION foo() ." thanx, goodbye. -- Sent via pga

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-12-02 Thread Dave Page
On Fri, Dec 2, 2016 at 10:39 AM, Peter Juhasz wrote: > On Fri, 2016-12-02 at 01:16 +, Dave Page wrote: >> On Thu, Dec 1, 2016 at 12:14 PM, Peter Juhasz > > wrote: > [...] > >> > Apparently the ApplicationPath setting must be a relative path, >> > absolute paths don't work (because of a bug at

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-12-02 Thread Peter Juhasz
On Fri, 2016-12-02 at 01:16 +, Dave Page wrote: > On Thu, Dec 1, 2016 at 12:14 PM, Peter Juhasz > wrote: [...] > > Apparently the ApplicationPath setting must be a relative path, > > absolute paths don't work (because of a bug at Server.cpp:221 where > > the > > code just blindly concatenates

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-12-01 Thread Dave Page
On Thu, Dec 1, 2016 at 12:14 PM, Peter Juhasz wrote: > On Wed, 2016-11-30 at 21:56 +0300, Devrim Gündüz wrote: >> On Tue, 2016-11-29 at 10:42 +0100, Peter Juhasz wrote: >> > >> > I've removed the previous pgadmin4-* packages then installed the >> > new >> > ones. >> >> That is not enough -- can yo

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-12-01 Thread Peter Juhasz
On Wed, 2016-11-30 at 21:56 +0300, Devrim Gündüz wrote: > On Tue, 2016-11-29 at 10:42 +0100, Peter Juhasz wrote: > > > > I've removed the previous pgadmin4-* packages then installed the > > new > > ones. > > That is not enough -- can you please also delete the directories that > I > mentioned her

Re: [pgadmin-support] pgadmin4 & runtime

2016-11-30 Thread Dave Page
Hi On Wed, Nov 30, 2016 at 7:07 PM, Dmitry Voronin wrote: > Hello, pgadmin4 team! > > I use pgadmin4 1.1 from official site on Ubuntu 14.04. > > I have Python 3.4.3, qt5 5.2.1 and I build a runtime component for running > pgadmin4 in client mode. > > I set venv via venv-3.4 in pgadmin4-1.1/venv.

Re: [pgadmin-support] PgAdmin4 not usable when installed from RPMs on Fedora linux

2016-11-30 Thread Devrim Gündüz
Hi, On Tue, 2016-11-29 at 10:38 +, Kieran McCusker wrote: > I'm having the same problem. I did install the earlier RPMs but removed  > them (and any mention I could find of pgAdmin4) before reinstalling. Can you please follow the instructions that I wrote here? https://www.postgresql.org/me

[pgadmin-support] pgadmin4 & runtime

2016-11-30 Thread Dmitry Voronin
Hello, pgadmin4 team! I use pgadmin4 1.1 from official site on Ubuntu 14.04. I have Python 3.4.3, qt5 5.2.1 and I build a runtime component for running pgadmin4 in client mode. I set venv via venv-3.4 in pgadmin4-1.1/venv. So, I run runtime part with command: $ cd pgadmin4-1.1/ $ ./runtime/pg

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-11-30 Thread Devrim Gündüz
On Tue, 2016-11-29 at 10:42 +0100, Peter Juhasz wrote: > I've removed the previous pgadmin4-* packages then installed the new > ones. That is not enough -- can you please also delete the directories that I mentioned here? https://www.postgresql.org/message-id/1479206529.4684.18.camel%40gunduz.org

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-11-29 Thread Peter Juhasz
On Tue, 2016-11-29 at 03:07 +0300, Devrim Gündüz wrote: > Hi, > > On Wed, 2016-11-23 at 14:12 +0100, Peter Juhasz wrote: > > > > I've installed the latest pgadmin4-v1 package from the PGDG > > repository. > > Unfortunately, it still does not work. > > > > Is this a fresh installation, or did y

[pgadmin-support] PgAdmin4 not usable when installed from RPMs on Fedora linux

2016-11-29 Thread Kieran McCusker
Hi I'm having the same problem. I did install the earlier RPMs but removed them (and any mention I could find of pgAdmin4) before reinstalling. Thanks Kieran -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-11-28 Thread Devrim Gündüz
Hi, On Wed, 2016-11-23 at 14:12 +0100, Peter Juhasz wrote: > I've installed the latest pgadmin4-v1 package from the PGDG repository. > Unfortunately, it still does not work. Is this a fresh installation, or did you upgrade from the previous RPMs? Regards, -- Devrim GÜNDÜZ EnterpriseDB: http:/

Re: [pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-11-23 Thread Dave Page
Adding Devrim... On Wed, Nov 23, 2016 at 1:12 PM, Peter Juhasz wrote: > Dear PgAdmin4 maintainers, > > I've installed the latest pgadmin4-v1 package from the PGDG repository. > Unfortunately, it still does not work. > > Now (as oppossed to the previous version of the package) there is a > pgadmin

[pgadmin-support] PgAdmin4 STILL not usable when installed from RPMs on Fedora linux

2016-11-23 Thread Peter Juhasz
Dear PgAdmin4 maintainers, I've installed the latest pgadmin4-v1 package from the PGDG repository. Unfortunately, it still does not work. Now (as oppossed to the previous version of the package) there is a pgadmin4 binary in the path, starting it results in the familiar "An error occurred initial

Re: [pgadmin-support] Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity

2016-11-18 Thread Dave Page
On Fri, Nov 18, 2016 at 2:33 PM, Doug Easterbrook wrote: > hi Dave: > > Yeah, I think what we need to do is either allow users to select which > columns they see in the preferences, or use the subnode control so you > can expand a row and see the additional info. Which do you think would > be pref

Re: [pgadmin-support] Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity

2016-11-18 Thread Doug Easterbrook
hi Dave: > Yeah, I think what we need to do is either allow users to select which > columns they see in the preferences, or use the subnode control so you > can expand a row and see the additional info. Which do you think would > be preferable? you asked about this — with our own users, we ar

Re: [pgadmin-support] Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity

2016-11-18 Thread Dave Page
Hi On Thu, Nov 17, 2016 at 3:43 PM, Doug Easterbrook wrote: > hi dave: > > A feature we used in pg admin 3 a fair bit was to terminate a rogue process > — it was easy enough looking at the list of processes and clicking on one > and hitting the terminate button. That's already logged at https://

[pgadmin-support] Pgadmin4: ability to terminate the backend process from the list of processes and highlight activity

2016-11-17 Thread Doug Easterbrook
hi dave: A feature we used in pg admin 3 a fair bit was to terminate a rogue process — it was easy enough looking at the list of processes and clicking on one and hitting the terminate button. why do we have rogue processes or things we want to kill — sometimes a customer may throw off a long

Re: [pgadmin-support] pgadmin4: enhancement request to remember column size rerunning a query

2016-11-17 Thread Malik Rumi
Yea, me too. I find the constant resizing annoying. But I still love PGAdmin4! On Thu, Nov 17, 2016 at 1:11 AM, Dave Page wrote: > On Wed, Nov 16, 2016 at 6:20 PM, Doug Easterbrook > wrote: > > hi dave. > > > > there are a number of times where we rerun a query in the sql browser. > we > > ad

Re: [pgadmin-support] pgAdmin4 Not working in Windows 10

2016-11-17 Thread Dave Page
Hi On Thu, Nov 17, 2016 at 1:28 PM, Ed Anderson wrote: > I read Nigel Tucker's issue with pgAdmin4 and Windows 10, as well as Dave > Page's response. I am having the same problem. I'm running pgsql 9.6 and > pgadmin 4.1.1 - the application crashes constantly. Most significantly when > attemptin

[pgadmin-support] pgAdmin4 Not working in Windows 10

2016-11-17 Thread Ed Anderson
I read Nigel Tucker's issue with pgAdmin4 and Windows 10, as well as Dave Page's response. I am having the same problem. I'm running pgsql 9.6 and pgadmin 4.1.1 - the application crashes constantly. Most significantly when attempting to open a database after a successful connection. It also crash

  1   2   3   >