| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Can't connect |
| Date: | 2009-10-29 17:24:40 |
| Message-ID: | 4AE9CFD8.7040606@archonet.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Pawley | 2009-10-29 17:53:09 | Re: Can't connect |
| Previous Message | Bob Pawley | 2009-10-29 17:08:23 | Can't connect |