Search Postgresql Archives

Re: Can't connect

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux