[postgis-users] Keep alive script

[Shaozhong SHI]

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
database.

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'?

Regards,
Shao

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>