orphaned psql's

If I understand it correctly, you use ssh/telnet/whatever to login to your remote server, Then you run psql on the server?

If you have a bad connection to your server, then you could consider using "screen" which will allow you to reattach (screen -R) to the running frontend on your next login.

/Mattias

----- Original Message -----
From: "CSN" <cool_screen_name90001@yahoo.com>
To: <pgsql-general@postgresql.org>
Sent: Monday, October 06, 2003 11:10 AM
Subject: [GENERAL] orphaned psql's

On Mon, 6 Oct 2003, CSN wrote:

Every now and then my connection to my remote server
will disconnect. If I was using the psql commandline,
"ps" will show it's still running (after I log back
on). Is there a way to get access to the running psql
process again, or cause it to disconnect and close? I
tried "kill" but it didn't do anything.

you should be able to suspend it then fg it I'd think.

On Mon, 6 Oct 2003, CSN wrote:

Every now and then my connection to my remote server
will disconnect. If I was using the psql commandline,
"ps" will show it's still running (after I log back
on). Is there a way to get access to the running psql
process again, or cause it to disconnect and close? I
tried "kill" but it didn't do anything.

Do you have a firewall between the machine running psql and the machine
running the server? Some firewalls have a short timeout for inactive
tcp-sessions.

--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&amp;search=0xB5A1AFE1