Stefan Loidl <Stefan(dot)Loidl(at)lrz-muenchen(dot)de> writes:
> is there a connection timeout in postgres?
> It seems to me that connections that are idle for about a day,
> are closed automatically by the corresponding postmaster process
> and the process exits.
No such mechanism in Postgres itself, but perhaps you are seeing the
effects of some timeout in your TCP stack.
(More usually, we get complaints from people who think there *should*
be a timeout ;-))
regards, tom lane