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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
