Re: Restart after poweroutage

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/
***-*--*----*-------*------------*--------------------*---------------

In response to

Responses

Browse pgsql-general by date

  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