Re: postgresql-8.3.7 unexpected connection closures

From: Andrew Maclean <andrew(dot)amaclean(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: justin <justin(at)emproshunts(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, General <pgsql-general(at)postgresql(dot)org>
Subject: Re: postgresql-8.3.7 unexpected connection closures
Date: 2009-06-22 23:28:41
Message-ID: e7ddbec60906221628q44fdd712ia51e475f2bc04a2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[snipity snip snip]

Notwithstanding all the previous discussion. I still think there is a
problem with postgresql on windows.

Messages in the log are consistently of the form:
2009-06-23 08:28:26 EST WARNING: worker took too long to start; cancelled
FATAL: could not reattach to shared memory (key=252, addr=023F0000): 487
2009-06-23 08:35:58 EST WARNING: worker took too long to start; cancelled
FATAL: could not reattach to shared memory (key=252, addr=023F0000): 487

Postgres is actually usable if I restart the service after the machine
has booted up. This fixes the problem triggering the 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."

However the above messages are still appearing.

Personally I have no issues with the installation process. Although I
am the first to admit that sometimes I forget to check the log file
and the event files. I get used to Linux.

Regards
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/
___________________________________________

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-06-22 23:33:06 Re: Slight change in query leads to unexpected change in query plan
Previous Message Sam Mason 2009-06-22 23:22:23 Re: Why my queryes doesnt not use indexes?