Thread: 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
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 > 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 >
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&search=0xB5A1AFE1