Re: Incompatibility with psycopg2 2.8

2019-04-04 Thread Khushboo Vashi
On Thu, Apr 4, 2019 at 9:44 PM H. v. Loewenfeld, Philipp wrote: > Hi, > > Thanks for the great work on pgadmin4. But after updating to 4.4 I could > login but trying to connect to my database I got an internal server error > “'psycopg2.extensions.Column' object has no attribute '_asdict'” -- > s

Re: Connection error after upgrading to v4.4

2019-04-04 Thread Khushboo Vashi
On Fri, Apr 5, 2019 at 4:59 AM Calle Hedberg wrote: > Hi > > I upgraded to 4.4 earlier this evening, and now a considerable number of > small scripts I'm running regularly fails with the following error that I > have not seen before: > > SSL SYSCALL error: Software caused connection abort (0x

Connection error after upgrading to v4.4

2019-04-04 Thread Calle Hedberg
Hi I upgraded to 4.4 earlier this evening, and now a considerable number of small scripts I'm running regularly fails with the following error that I have not seen before: SSL SYSCALL error: Software caused connection abort (0x2745/10053) Would any of the 4.4 fixes or changes cause this issu

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
Thanks for the kind (and quick) replies. My last email crossed with the ones from Dave and Murtaza... On Thu, 4 Apr 2019 at 19:03, Dave Page wrote: > > Downgrade psycopg2 to 2.7.7 (or whatever came before 2.8). Apparently they > broke backwards compatibility:-( > > -- > Dave Page > Blog: http://

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
On Thu, 4 Apr 2019 at 17:57, Shaheed Haque wrote: > > Woah, rabbithole time... > > On Thu, 4 Apr 2019 at 17:33, Shaheed Haque wrote: > > > > I can login, but when I click on "Servers", nothing happens on screen > > and the error log gets this: > > > > [2019-04-04 16:10:10 +] [5850] [INFO] Sta

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Dave Page
Downgrade psycopg2 to 2.7.7 (or whatever came before 2.8). Apparently they broke backwards compatibility:-( -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK:http://www.enterprisedb.com The Enterprise PostgreSQL Company > On 4 Apr 2019, at 17:33, Shaheed Haque w

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
Woah, rabbithole time... On Thu, 4 Apr 2019 at 17:33, Shaheed Haque wrote: > > I can login, but when I click on "Servers", nothing happens on screen > and the error log gets this: > > [2019-04-04 16:10:10 +] [5850] [INFO] Starting gunicorn 19.9.0 > [2019-04-04 16:10:10 +] [5850] [INFO] Li

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
I can login, but when I click on "Servers", nothing happens on screen and the error log gets this: [2019-04-04 16:10:10 +] [5850] [INFO] Starting gunicorn 19.9.0 [2019-04-04 16:10:10 +] [5850] [INFO] Listening at: unix:/home/ubuntu/pgadmin.sock (5850) [2019-04-04 16:10:10 +] [5850] [IN

Incompatibility with psycopg2 2.8

2019-04-04 Thread H. v. Loewenfeld, Philipp
Hi, Thanks for the great work on pgadmin4. But after updating to 4.4 I could login but trying to connect to my database I got an internal server error “'psycopg2.extensions.Column' object has no attribute '_asdict'” -- sometimes the error message was displayed via the browser interface, someti

pgAdmin 4.4 SQL create statement

2019-04-04 Thread Irina Mileva
Thank you for the new version. DDL seems to give a bit unexpected result. [cid:image001.jpg@01D4EB0B.FA3CE750]

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Dave Page
Hi It worked fine when I tested it. If you don't get any errors and you get a login prompt, it should all be good. On Thu, Apr 4, 2019 at 3:01 PM Shaheed Haque wrote: > Hi Dave, > > I'm just migrating to the fixes in 4.4. Can I just double check one > thing? In my original hack, I needed to cre

Re: Hosting pgAdmin4 behind nginx and at /pgdmin, for mortals

2019-04-04 Thread Shaheed Haque
Hi Dave, I'm just migrating to the fixes in 4.4. Can I just double check one thing? In my original hack, I needed to create a link "wsgi.py" -> "pgAdmin4.py", so the the corresponding gunicorn command is something like this: gunicorn ... --bind unix:/.../pgadmin.sock wsgi:application Now, in

pgAdmin 4 v4.4 released

2019-04-04 Thread Akshay Joshi
The pgAdmin Development Team are pleased to announce pgAdmin 4 version 4.4. This release of pgAdmin 4 includes over 35 bug fixes and new features. For more details please see the release notes at: https://www.pgadmin.org/docs/pgadmin4/dev/release_notes_4_4.html. pgAdmin is the leading Open So