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

[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

On Thu, Apr 2, 2020 at 1:12 PM larry price <laprice at gmail.com> wrote:

> 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 <cpatterson at psdrcs.com>
> wrote:
>
>> 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 probably means the server terminated abnormally
>>
>> 	before or while processing the request.
>>
>> The only way to get it working again is to close/open DB Manager. Clicking re-connect on the database just causes DB Manager to freeze up.
>>
>> Thanks,
>>
>> Cliff
>>
>>
>> --
>>
>> Cliff Patterson Ph.D.
>>
>> *PSD* | Senior GIS Consultant
>> P: 519-690-2565 ext. 2616
>> www.psdrcs.com
>> London | 148 Fullarton St. 9th Floor
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>

-- 

Cliff Patterson Ph.D.

*PSD* | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com
London | 148 Fullarton St. 9th Floor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200407/25b18c04/attachment.html>