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

[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 <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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200402/5ea36b17/attachment.html>