[XP SP2/SP3] FATAL: could not reattach to shared memory - Mailing list pgsql-general

Hi,

We have problems with PostgreSQL on Windows.

PostgreSQL: 8.3.1
System: Windows XP (SP3)
FS: NTFS
Hardware: IBM x3650, 1x Xeon Quad, 2GB RAM


The database is accessed from multiple windows apps. One of them has a
connection pool, the others use single connection per app.
Somethimes when I start PgAdmin and then our app, the second one freeze
(not a PgAdmin bug, the same issue is with other apps).
The log contains:

FATAL:  could not reattach to shared memory (key=1808, addr=01CC0000): 487
FATAL:  could not reattach to shared memory (key=1808, addr=01CC0000): 487
2008-06-24 06:36:11 CEST WARNING:  worker took too long to start; cancelled

Errors appears on Windows XP SP2 too.

On Windows 2000 we have never noticed memory errors like above - on very
similar configuration (but with win2k) the PostgreSQL works perfectly.

Anybody have any idea about this?

Thanks,

--
Łukasz Czerpak | PGP: 0xCBEAA46D [subkeys.pgp.net]
Bankowość Elektroniczna
SoftNet Sp. z o.o.
http://www.softnet.pl/