471,354 Members | 2,208 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

orphaned psql's

CSN
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

Nov 12 '05 #1
3 1715
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

Nov 12 '05 #2
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.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #3
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/pk...rch=0xB5A1AFE1

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

15 posts views Thread by Daniel Schuchardt | last post: by
7 posts views Thread by Willem Herremans | last post: by
4 posts views Thread by Brendan Jurd | last post: by
15 posts views Thread by Dino Vliet | last post: by
1 post views Thread by Josué Maldonado | last post: by
2 posts views Thread by Russ Brown | last post: by
33 posts views Thread by John Sidney-Woollett | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.