I am on Windows and am running an anti virus program. But I was running the
same programs on Windows before without this problem.
Bob
----- Original Message -----
From: "Richard Huxton" <dev@archonet.com>
To: "Bob Pawley" <rjpawley@shaw.ca>
Cc: <pgsql-general@postgresql.org>
Sent: Thursday, October 29, 2009 10:24 AM
Subject: Re: [GENERAL] 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
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general