Skip site navigation (1) Skip section navigation (2)

Re: Leftover TEMPORARY tables?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Biagioni <andrew(dot)biagioni(at)e-greek(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Leftover TEMPORARY tables?
Date: 2003-04-24 16:58:17
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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 LaneDate: 2003-04-24 17:03:30
Subject: Re: How to suppress errors from postmaster log?
Previous:From: Andrew BiagioniDate: 2003-04-24 16:39:34
Subject: Re: Leftover TEMPORARY tables?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group