Re: Can't connect

Bob Pawley wrote:
> Hi
>
> My copy of PostgreSQL version 8.3 has decided not to receive a
> connection after an idle time measured in hours.

Odd.

> It acceptes the connection one I stop the server and then restart. At
> this point, it always asks for the password.
>
> Here is the log of the event -
>
> FATAL:  could not reattach to shared memory (key=1804,
> addr=01700000): 487 2009-10-29 00:19:20 PDT WARNING:  worker took too
> long to start; cancelled

That "worker took too long..." message is from autovaccuum, so I'm not
sure it's directly responsible. The "could not reattach to shared
memory" error looks familiar though.

Are you:
1. On Windows?
2. Running some sort of anti-virus?

Also, you might want to read this news item from September:
  http://www.postgresql.org/about/news.1135

Are you already on 8.3.8?

--
  Richard Huxton
  Archonet Ltd