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: