Re: Backend failure...

This is a total wag:

Are you running postmaster as a service?

// m

> -----Original Message-----
> From: pgsql-cygwin-owner@postgresql.org
> [mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Robert J.
> Sanford, Jr.
> Sent: Thursday, July 18, 2002 12:32 PM
> To: pgsql-cygwin@postgresql.org
> Subject: [CYGWIN] Backend failure...
>
>
> I am running PostgreSQL 7.2 using the cygwin libs. The server
> platform is a
> Win2K machine with lots of RAM and lots of drive space.
>
> The clients that I have been using are
> a) the Mac OSX psql client pre-built by Marc Liyange and
> b) Perl DBI
>
> I can dupe this very consistently...
>
> I get into a terminal window and use psql to connect to the database. I
> start up another terminal window and kick off a Perl app that
> parses a bunch
> of data files and dumps them to the server. Total running time is about
> fifteen minutes if it doesn't crater. Most of that time is spent in my bad
> Perl code :)
>
> If I allow the client machine to go into screen saver mode then I
> will get a
> message saying that the server has detected a backend failure and all
> clients have been disconnected. Actually, the service has shut itself down
> and I have to get to the server and restart it.
>
> If I don't run the psql client it doesn't happen. I'm guessing
> that when the
> screensaver kicks in the psql client tries to go to sleep but something
> nasty happens and the server goes down.
>
> While I can work around the psql client not being there, the server should
> not go down.
>
> rjsjr
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
> -
>
>

-