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" <co*******************@yahoo.com>
To: <pg***********@postgresql.org>
Sent: Monday, October 06, 2003 11:10 AM
Subject: [GENERAL] orphaned psql's
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.
TIA,
CSN
__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html