[postgis-users] Postgres Timeouts

[Darafei "Komяpa" Praliaskouski]

alter system set statement_timeout to '5min';

Locally we use 6 hour timeout, so an evening started job would be finished,
or slaughtered, by morning.

ср, 11 апр. 2018 г. в 18:39, Aaron Edwards <aedwards at b3insight.com>:

> Hi,
>
>
>
> My ETL process requires that I issue several long-running queries to
> postgresql.  Queries like building indexes, updating SRIDs, that kind of
> thing.
>
>
>
> My problem is that if the query takes too long to run, something over 5
> minutes (but I don’t know the actual number for certain), then the query
> never returns.  I’ve set the ConnectionTimeout property of the connection
> to 0, which I understand is no timeout.  But the command is timing out
> anyway.  Often times I can see that the command has completed successfully,
> by looking for the presence of the objects the command is creating in pg
> Admin.  But the script still hangs, because as far as it knows, postres is
> still processing it’s previous command.
>
>
>
> Is there a default timeout setting that is global to a postgresql database
> or server?
>
>
>
> Thanks.
>
>
>
> Aaron
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180411/fb1a636a/attachment.html>