Re: [GENERAL] pgsql over ISDN lines ... - Mailing list pgsql-general

From Marten Feldtmann
Subject Re: [GENERAL] pgsql over ISDN lines ...
Date
Msg-id 200001272014.VAA16069@feki.toppoint.de
Whole thread Raw
In response to Re: [GENERAL] pgsql over ISDN lines ...  (Peter Mount <peter@retep.org.uk>)
List pgsql-general
> On Tue, 25 Jan 2000, Marten Feldtmann wrote:
>
> > I've tried to use PostgreSQL over ISDN lines with about a timeout
> > of ~60 seconds - when no traffic is done, the line is dropped.
> >
>
> Hmmm, I've just tried this, and it worked for me.
>
> I've got ISDN here, so I setup a test server on one of my linux boxes at
> work, then dropped the line.
>
> I then tested #1 buy connecting to the server. It connected fine.
>
> I then issued a query, which worked, then dropped the ISDN connection
> (with the psql one still running).
>
> With the ISDN down, I then issued another query using psql, and the ISDN
> line came up, and after a couple of seconds, the query results were
> returned.
>

 Ok, I've now done some further tests and I've found the reason, why
my application process was not able to continue ....

 The reason was, that the backend process terminated when the isdn
line went down.

 What have I done:

 telnet to remote server pc and start the postmaster.

 Now doing several sql-command using psql ...

 now do nothing, line is dropped ....

 now I try to execute some psql commands .. but they failed.

 telnet to server: postmaster is still running, but backend process is
not there ...



 Marten


 Any idea ?




pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] Large Functions and Index Rebuild
Next
From: John Brothers
Date:
Subject: Re: [GENERAL] Problem with SELECT on large negative INT4