Re: Restart after poweroutage - Mailing list pgsql-general

From Jon Lapham
Subject Re: Restart after poweroutage
Date
Msg-id 45F6F1EE.3070509@jandr.org
Whole thread Raw
In response to Re: Restart after poweroutage  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Restart after poweroutage  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Jon Lapham <lapham@jandr.org> writes:
>> What can I do to help diagnose what is happening?
>
> Let's see the output from
> ps auxww | grep postgres
> sudo ipcs -a

[root@bilbo ~]# ps auxww | grep postgres
root      3969  0.0  0.0  60272   688 pts/1    R+   15:47   0:00 grep
postgres
[root@bilbo ~]# ipcs -a

------ Shared Memory Segments --------
key        shmid      owner      perms      bytes      nattch     status

0x00000000 65536      root      777        172032     1

0x00000000 131073     lapham    600        393216     2          dest

0x00000000 163842     lapham    600        393216     2          dest

0x00000000 196611     lapham    600        393216     2          dest

0x00000000 229380     lapham    600        393216     2          dest

0x00000000 262149     lapham    600        393216     2          dest

0x00000000 294918     lapham    600        393216     2          dest

0x00000000 327687     lapham    600        393216     2          dest

0x00000000 360456     lapham    600        393216     2          dest

0x00000000 393225     lapham    600        393216     2          dest

0x00000000 425994     lapham    600        393216     2          dest

0x00000000 458763     lapham    600        393216     2          dest

0x00000000 491532     lapham    600        393216     2          dest

0x00000000 524301     lapham    600        393216     2          dest

0x00000000 557070     lapham    600        393216     2          dest

0x00000000 589839     lapham    600        393216     2          dest

0x00000000 819219     lapham    666        43200      1          dest


------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0x00000000 65536      apache    600        1
0x00000000 32769      apache    600        1
0x00000000 98306      apache    600        1
0x00000000 131075     apache    600        1
0x00000000 163844     apache    600        1
0x00000000 196613     apache    600        1
0x00000000 229382     apache    600        1
0x00000000 262151     apache    600        1

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages


--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
  Jon Lapham  <lapham@jandr.org>                Rio de Janeiro, Brasil
  Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Restart after poweroutage
Next
From: Tom Lane
Date:
Subject: Re: Restart after poweroutage