Re: BUG #5260: Postgre crashed unexpectedly

On Mon, Jan 4, 2010 at 5:29 AM, Toni Helenius
<toni(dot)helenius(at)syncrontech(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5260
> Logged by:          Toni Helenius
> Email address:      toni(dot)helenius(at)syncrontech(dot)com
> PostgreSQL version: 8.3.9
> Operating system:   Windows 2008 Server Enterprise
> Description:        Postgre crashed unexpectedly
> Details:
>
> Postgre database was running normally and several applications using it
> normally like any other day. Then the Postge just died and didn't recover by
> itself.. Here is the log:
[...]
> 2009-12-31 13:41:20 EET FATAL:  pre-existing shared memory block is still in
> use
> 2009-12-31 13:41:20 EET HINT:  Check if there are any old server processes
> still running, and terminate them.

Per the hint, did you check whether there are any old server processes
still running?

If you don't find any old server processes running, I would guess that
a reboot would likely be a good next step toward getting the system
back up.

Unfortunately I'm not sure what could have caused the original crash.

...Robert