postgresql-8.3.7 unexpected connection closures - Mailing list pgsql-general

From Andrew Maclean
Subject postgresql-8.3.7 unexpected connection closures
Date
Msg-id e7ddbec60906181612p173ee9h630eaff509dab161@mail.gmail.com
Whole thread Raw
Responses Re: postgresql-8.3.7 unexpected connection closures
List pgsql-general
I posted this a while back but got no useful responses.

I have the following error message:

"Error connecting to the server: server closed the connection unexpectedly.
 This probably means that the server terminated abnormally before or
while processing the request."

It happens intermittently both when using pgAdminIII and when using QT
so it is not a pgAdminIII issue.

Often the connection seems to succeed but you get a series of error
messages like the one above when attempting to open a database. It
seems to be a timing issue.

This is happening when using a local connection on vista, irrespective
of whether the antivirus is on or off. I can't see anything to change
in postgresql.conf that could alleviate this problem.

This does not happen with postgresql-8.3.5 but does happen with
postgresql-8.3.7.

This is happening on two different machines (both Vista SP2) running
different antivirus programs so I suspect there has been some change
to postgres that has triggered this problem.

Postgres has become unuseable on these machines.

Thanks for may help

Andrew

--
___________________________________________
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney  2006  NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
___________________________________________

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4
Next
From: Craig Ringer
Date:
Subject: Re: postgresql-8.3.7 unexpected connection closures