Thread: 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
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 > - > > -
Yes. > -----Original Message----- > From: Mark McEahern [mailto:marklists@mceahern.com] > Sent: Thursday, July 18, 2002 12:47 PM > To: Robert J. Sanford, Jr.; pgsql-cygwin@postgresql.org > Subject: RE: [CYGWIN] 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 > > - > > > > > > - > >