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
