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@xxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: <pgsql-general@xxxxxxxxxxxxxx>
Sent: Thursday, October 29, 2009 10:24 AM
Subject: 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general