| From: | Holger Marzen <holger(at)marzen(dot)de> |
|---|---|
| To: | CSN <cool_screen_name90001(at)yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: orphaned psql's |
| Date: | 2003-10-15 17:48:46 |
| Message-ID: | Pine.LNX.4.58.0310151947400.16013@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-10-15 17:54:49 | Re: VACUUM degrades performance significantly. Database |
| Previous Message | Stephen | 2003-10-15 17:36:15 | Re: VACUUM degrades performance significantly. Database becomes unusable! |