Re: connection timeout? - Mailing list pgsql-novice

From Tom Lane
Subject Re: connection timeout?
Date
Msg-id 20210.1170611121@sss.pgh.pa.us
Whole thread Raw
In response to Re: connection timeout?  (Frank Bax <fbax@sympatico.ca>)
List pgsql-novice
Frank Bax <fbax@sympatico.ca> writes:
> Script and database are both on same system.  Faster system was able
> to get past next database access.  So far so good, script continues
> to run.  Still curious why it failed on slower system, though.

There's no connection timeout built into PG itself.  The message implies
that something sent the backend a SIGTERM signal, which makes me wonder
if you are running the postmaster under ulimit settings that include
a finite limit on process CPU or I/O expenditure.  Some platforms have
special signals for that (SIGXCPU etc) but I think some just send
SIGTERM when a process goes over the limit.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Shoaib Mir"
Date:
Subject: Re: connection timeout?
Next
From: Tom Lane
Date:
Subject: Re: Accessing RECORD variable info