I wish I had more to suggest to you. We are working on a few problems with semaphore on Win2003 SP1, but nothing related to shared memory.
--------------------------------------------------------------------------- Andy Male wrote: > > The following bug has been logged online: > > Bug reference: 2419 > Logged by: Andy Male > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Windows 2003 Server (standard) SP1 > Description: could not reattach to shared memory > Details: > > FULL ERROR IN WINDOWS EVENT LOG - > > The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found. > The local computer may not have the necessary registry information or > message DLL files to display messages from a remote computer. You may be > able to use the /AUXSOURCE= flag to retrieve this description; see Help and > Support for details. The following information is part of the event: FATAL: > could not reattach to shared memory (key=5432001, addr=01960000): Invalid > argument > > There is no correspondng error in pg_log. > > Once the error happens the database become unreponsive, current connections > stop responding and you cannot make new connections. Stopping and starting > the database removes the error and normal operation can continue. > > The error happens intermittently (three or four times a day) and doesn't > seem to have a specific cause. The database is not heavily used and is > processing around 100 transactions per minute. > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq > -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
