Re: Leftover TEMPORARY tables? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Leftover TEMPORARY tables?
Date
Msg-id 14609.1051203497@sss.pgh.pa.us
Whole thread Raw
In response to Re: Leftover TEMPORARY tables?  (Andrew Biagioni <andrew.biagioni@e-greek.net>)
List pgsql-admin
Andrew Biagioni <andrew.biagioni@e-greek.net> writes:
> OK, Option 2:  I use an SSH connection to tunnel port 5432 from my Windows
> machine to the DB machine (Red Hat 7.3);  occasionally the SSH connection
> drops, and so does the tunnel.  Could that explain the temp tables?

Nope, don't like that either.  It might take a little while for the
kernel to realize the connection is dead, but once it does, the backend
will see EOF on its input and will clean up and exit.

            regards, tom lane


pgsql-admin by date:

Previous
From: Andrew Biagioni
Date:
Subject: Re: Leftover TEMPORARY tables?
Next
From: Tom Lane
Date:
Subject: Re: How to suppress errors from postmaster log?