[postgis-users] Keep alive script

Shaozhong SHI shishaozhong at gmail.com
Mon Jan 13 14:28:16 PST 2020

Psql may carry out large queries on big data sets.  These operations may
take a long time to complete.  It occurs that psql loses connection to the

When a do loop is created to limit queries to range of rows at a time,
engagement between psql and postures can be maintained.  However, this
could take a long time.

Disconnection between psql and posters is understood due to timeout.

Is there a way to create a 'keep life script'?


On Monday, 13 January 2020, Stephen Woodbridge <
stephenwoodbridge37 at gmail.com> wrote:

> On 1/13/2020 6:10 AM, Shaozhong SHI wrote:
>> With long running processes, time-out could be an issue.
>> Has anyone got experience in creating a "Keep alive script" solution to
>> share?
> Need more information.
> What is timing out? ssh, php, psql, etc?
> _______________________________________________
> 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/20200113/83f1a346/attachment.html>

More information about the postgis-users mailing list