Re: PostgreSQL crashes with Qmail-SQL

Michael Devogelaere <michael@digibel.be>

From: Michael Devogelaere <michael@digibel.be>
To: Jan Wieck <janwieck@yahoo.com>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>, Justin Clift <justin@postgresql.org>, michael@digibel.be, PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Date: 2002-01-24T14:28:15Z
Lists: pgsql-hackers
>     As  the  doc  says,  all  done  totally untuned. And CRASH by
>     itself doesn't say anything. A little more precise  would  be
>     good.
Ok: the client reported something like: 
"Unexpected EOF from PostgreSQL-backend". When looking with ps aux, i noted
that all postmaster-childs where <defunct>. I couldn't connect anymore with
psql (i aborted the test and no other processes tried to access the database
since my machine was in single user mode). After killing the master process and
restarting, the database worked fine.
> 
>     Other  than  that,  once  again one of these mostly read only
>     scenarios with simple queries where it is well known  that  a
>     real database cannot compete.
True: i planned two tests. One big read-only test and then another which would 
add simulation of pop-logins. After a successful pop-login the field 
'lastlogin' is updated. But i didn't run that test since postgresql already 
failed the simple read-only test.

Kind regards,
Michael Devogelaere.