From: | Jon Lapham <lapham(at)jandr(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Restart after poweroutage |
Date: | 2007-03-13 18:48:14 |
Message-ID: | 45F6F1EE.3070509@jandr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> Jon Lapham <lapham(at)jandr(dot)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(at)bilbo ~]# ps auxww | grep postgres
root 3969 0.0 0.0 60272 688 pts/1 R+ 15:47 0:00 grep
postgres
[root(at)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(at)jandr(dot)org> Rio de Janeiro, Brasil
Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-03-13 18:51:58 | Re: Restart after poweroutage |
Previous Message | Tom Lane | 2007-03-13 18:38:33 | Re: Restart after poweroutage |