Aw: Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

2019-09-04 Thread Holger Kopp-Musick
Hi Aditya,   pgAdmin 4.12 is on Windows 10 Enterprise x64 1809, PostgreSQL 10.9 on CentOS Linux 7.6.1810.   Thanks again, Holger   Gesendet: Mittwoch, 04. September 2019 um 14:01 Uhr Von: "Aditya Toshniwal" An: "Holger Kopp-Musick" Cc: "pgadmin-support lists.postgresql.org" , "Khushboo Vas

Re: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

2019-09-04 Thread Aditya Toshniwal
Hi Holger, Could you please tell us the OS details for both Postgres and pgAdmin ? On Wed, Sep 4, 2019 at 4:24 PM Holger Kopp-Musick wrote: > Hi, > > thank you very much for your help, indeed it looks like a problem with > signed/unsigned values. I'll stay with 4.10 meanwhile. > > Best regards,

Re: Bad Cookies with reverse proxy

2019-09-04 Thread Albert Serrallé
It works like a charm :) Thanks a lot for the fast reply, you saved my day! On Wed, 4 Sep 2019 at 13:29, Murtuza Zabuawala < murtuza.zabuaw...@enterprisedb.com> wrote: > Hi, > > If you are using latest version then could you please try setting > ENHANCED_COOKIE_PROTECTION > = False in your confi

Re: Bad Cookies with reverse proxy

2019-09-04 Thread Murtuza Zabuawala
Hi, If you are using latest version then could you please try setting ENHANCED_COOKIE_PROTECTION = False in your config_local.py file? We have recently added this config parameter for similar kind of issue. Ref: https://redmine.postgresql.org/issues/4566 -- Regards, Murtuza Zabuawala Enterprise

Bad Cookies with reverse proxy

2019-09-04 Thread Albert Serrallé
Hello, I've been trying to setup a pgadmin on Kubernetes behind an nginx ingress that handles the TLS termination. I cannot modify the configuration of that ingress, so I've deployed an additional nginx to handle the reverse proxy config for pgadmin: nginx ingress (tls termination) -> nginx -> pg

Aw: Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

2019-09-04 Thread Holger Kopp-Musick
Hi,   thank you very much for your help, indeed it looks like a problem with signed/unsigned values. I'll stay with 4.10 meanwhile.   Best regards, Holger   Gesendet: Mittwoch, 04. September 2019 um 12:27 Uhr Von: "Aditya Toshniwal" An: "Holger Kopp-Musick" Cc: "pgadmin-support lists.post

Re: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

2019-09-04 Thread Aditya Toshniwal
Hi, I had raised the concern on psycopg2 ( https://github.com/psycopg/psycopg2/issues/661#issuecomment-527739621) and looks like it is a bug in pyscopg2. Refer - https://github.com/psycopg/psycopg2/issues/961 We need wait psycopg2 now to get this fixed. On Wed, Sep 4, 2019 at 12:50 PM Holger Kop

Re: Are there any web-client-side calls to the database from pg admin?

2019-09-04 Thread Dave Page
Hi On Wed, Sep 4, 2019 at 9:02 AM Aidan Hoolachan wrote: > Hello, > > We are using AWS to host a postgresql server and we would like to keep the > database as isolated as possible from external networks. We plan to provide > a route from the pgAdmin host to the database, and then to provide a ht

Are there any web-client-side calls to the database from pg admin?

2019-09-04 Thread Aidan Hoolachan
Hello, We are using AWS to host a postgresql server and we would like to keep the database as isolated as possible from external networks. We plan to provide a route from the pgAdmin host to the database, and then to provide a http route from pgAdmin to our network for access in the browser. We ho

Aw: Re: Negative values for obj_id: SELECT statements throwing errors in query editor

2019-09-04 Thread Holger Kopp-Musick
Hi, thank you very much for your advice, I have attached the log. As proposed I've replaced the original file and restarted the server, yet unfortunately I'm still unable to get any results for any simple statement (ie SELECT * FROM table). In my understanding the obj_id is anyhow faulty since