postgres crashes - "not reattach to shared memory "

From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Cc: "Primor, Shay" <Shay_Primor(at)bmc(dot)com>
Subject: postgres crashes - "not reattach to shared memory "
Date: 2010-05-02 07:26:12
Message-ID: 2C0926ABD16BB641A8E2F11A5492004227832AFF7B@PHXCCRPRD01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi

Postgres crashes with -

PG "FATAL: could not reattach to shared memory (key=5432001, addr=02100000): Invalid argument.

The version is 8.2.4, the platform is win32

Does someone know the reason/workaround ?

Thanks,
Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
yuval_sofer(at)bmc(dot)com

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Enrico Weigelt
Sent: Saturday, May 01, 2010 7:51 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] linux standard layout

* Rodger Donaldson <rodgerd(at)diaspora(dot)gen(dot)nz> wrote:

> Agreed. This is particularly the case once one starts thinking about
> security updates and so on - my experience is that hand-rolling from
> source tends to result in patching lagging far behind after a while.

Depends on whether you have an proper QM and build machinery in the
back. I'm often work in embedded or specific appliance environments
and have developed my several tools which make this easier.
(feel free to contact me personally if you're interested)

cu
--
---------------------------------------------------------------------
Enrico Weigelt == metux IT service - http://www.metux.de/
---------------------------------------------------------------------
Please visit the OpenSource QM Taskforce:
http://wiki.metux.de/public/OpenSource_QM_Taskforce
Patches / Fixes for a lot dozens of packages in dozens of versions:
http://patches.metux.de/
---------------------------------------------------------------------

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Krajmalnik 2010-05-03 03:17:04 Re: Autovacuum stopped running
Previous Message Tom Lane 2010-05-02 02:54:17 Re: Fresh build on OS X not working (memory)