Re: [Qgis-user] PostGIS connections time out in Database Manager

2020-04-07 Thread Cliff Patterson
Hi Larry, Both those settings are set to default. I create/delete many PostGIS connections, so I suspect at this point that something in the profile data folder is buggy. My plan is to delete the profile folder, reinstall from scratch, and see if the problem persists. Will report back. Cliff

Re: [Qgis-user] PostGIS connections time out in Database Manager

2020-04-02 Thread larry price
Which version of postgres are you using and have you set a statement_timeout or idle_in_transaction_session_timeout in postgres. On Thu, Apr 2, 2020 at 9:45 AM Cliff Patterson wrote: > Hi QGISers, > > Does anyone know if there is a way to avoid being timed out when > connecting to a

[Qgis-user] PostGIS connections time out in Database Manager

2020-04-02 Thread Cliff Patterson
Hi QGISers, Does anyone know if there is a way to avoid being timed out when connecting to a Postgres/PostrGIS database using Database Manager? If I leave DB Manager open for a while (~10min) with no activity, I get the following error: server closed the connection unexpectedly This