From: | "Mark McEahern" <marklists(at)mceahern(dot)com> |
---|---|
To: | "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)trefs(dot)com>, <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Re: Backend failure... |
Date: | 2002-07-18 17:47:23 |
Message-ID: | JHEOKEOOLIGLDHCMAHMOEEDMDCAA.marklists@mceahern.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
This is a total wag:
Are you running postmaster as a service?
// m
> -----Original Message-----
> From: pgsql-cygwin-owner(at)postgresql(dot)org
> [mailto:pgsql-cygwin-owner(at)postgresql(dot)org]On Behalf Of Robert J.
> Sanford, Jr.
> Sent: Thursday, July 18, 2002 12:32 PM
> To: pgsql-cygwin(at)postgresql(dot)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
> -
>
>
-
From | Date | Subject | |
---|---|---|---|
Next Message | Robert J. Sanford, Jr. | 2002-07-18 17:55:15 | Re: Backend failure... |
Previous Message | Robert J. Sanford, Jr. | 2002-07-18 17:32:03 | Backend failure... |