Re: accessing a database out of network

check the pga_hba.conf file. and look at the server logs. if it says it is rejecting your ip address.. then you’ll know to reconfig the pg_hba.conf file and reload it within the server. Doug Easterbrook Arts Management Systems Ltd. mailto:d...@artsman.com http://www.artsman.com Phone (403)

Operators

HI is there a reason why the new pgAdmin don't show the operators in the database ? We created some operators in our Database ans it would be helpful to see them. Greetings Jürgen Spatz

accessing a database out of network

Hello, I am seeking advice for how to access a client database remotely via PGAdmin4 (or 3). I'm able to access it from my office, but not from my home, even when I have a virtual private network set up. This is something that functioned well up until about a month or two ago. Now I keep

Re: Connection error after upgrading to v4.4

Hi On Fri, Apr 5, 2019 at 12:41 PM Calle Hedberg wrote: > Dave, > > The scripts are just normal select, update and delete queries, running in > the script window against a remote server (logged in using pgremote). > I'm not sure what pgremote is, and Google isn't being helpful > > In any

Re: Connection error after upgrading to v4.4

Dave, The scripts are just normal select, update and delete queries, running in the script window against a remote server (logged in using pgremote). In any case - I rebooted everything and haven't seen the error again, so it might have been caused by some intermittent problem. Best regards

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

This issue is tracked here: https://redmine.postgresql.org/issues/4143. On Thu, 4 Apr 2019 at 19:06, Shaheed Haque wrote: > > 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: > > > >

Re: pgAdmin 4.4 SQL create statement

Did you notice the ID column is listed twice (and seems to think it's a serial column)? On Fri, Apr 5, 2019 at 8:30 AM Khushboo Vashi < khushboo.va...@enterprisedb.com> wrote: > Hi Irina, > > On Thu, Apr 4, 2019 at 8:00 PM Irina Mileva > wrote: > >> Thank you for the new version. >> >> DDL

Re: pgAdmin 4.4 SQL create statement

Hi Irina, On Thu, Apr 4, 2019 at 8:00 PM Irina Mileva wrote: > Thank you for the new version. > > DDL seems to give a bit unexpected result. > We have added support for IDENTITY column (with the sequence options) in the latest release, so this is the side effect of that feature. Please create

Re: Incompatibility with psycopg2 2.8

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'” -- >

Re: Connection error after upgrading to v4.4

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