Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)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
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2003-04-24 17:03:30|
|Subject: Re: How to suppress errors from postmaster log? |
|Previous:||From: Andrew Biagioni||Date: 2003-04-24 16:39:34|
|Subject: Re: Leftover TEMPORARY tables? |