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