Re: Restart after poweroutage - Mailing list pgsql-general

From Tom Lane
Subject Re: Restart after poweroutage
Date
Msg-id 24641.1159277249@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restart after poweroutage  (Jon Lapham <lapham@jandr.org>)
Responses Re: Restart after poweroutage
Re: Restart after poweroutage
List pgsql-general
Jon Lapham <lapham@jandr.org> writes:
> Is it important for you to know that at the time of the power outage, I
> *did* have 2 closed source kernel modules loaded, vmware's and NVidia's.
>   (This is a development machine, not production...).  Could one of
> these modules screwed up somehow and trampled on postgres's shared
> memory space?  Anyway, just thought I'd mention it.

Well, that's potentially interesting.  Do you have things configured to
load those automatically on boot?

> ------ Shared Memory Segments --------
> key        shmid      owner      perms      bytes      nattch     status
> 0x00000000 0          root      777        94208      0
> 0x6a6b6cbd 53411843   lapham    600        384        0
> 0x12ac1925 53444612   lapham    600        131072     0
> 0x000a1de2 41451525   lapham    600        1          0
> 0x6499077f 41484294   lapham    600        1          0

Anyone have any idea what the above entries are from?  The root-owned,
world-writable one seems a bit odd in particular.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Add serial in specific order?
Next
From: "Thomas Peter"
Date:
Subject: change the order of FROM selection to make query work