postgresql-8.3.7 unexpected connection closures

From: Andrew Maclean <andrew(dot)amaclean(at)gmail(dot)com>
To: General <pgsql-general(at)postgresql(dot)org>
Subject: postgresql-8.3.7 unexpected connection closures
Date: 2009-06-18 23:12:54
Message-ID: e7ddbec60906181612p173ee9h630eaff509dab161@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/
___________________________________________

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2009-06-19 00:40:25 Re: postgresql-8.3.7 unexpected connection closures
Previous Message Tom Lane 2009-06-18 22:18:16 Re: FYI: Load times for a largish DB in 8.2 vs. 8.3 vs. 8.4