Skip site navigation (1) Skip section navigation (2)

Re: Postgres server crash

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgres server crash
Date: 2006-11-16 14:01:28
Message-ID: b42b73150611160601s6c76b11blba7114bf17a21ddd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 11/15/06, Craig A. James <cjames(at)modgraph-usa(dot)com> wrote:

> Questions:
>   1. Any idea what happened and how I can avoid this?  It's a *big* problem.
>   2. Why didn't the database recover?  Why are there two processes
>      that couldn't be killed?
>   3. Where did the "signal 9" come from?  (Nobody but me ever logs
>      in to the server machine.)

how much memory is in the box?  maybe vmstat will give you some clues
about what is going on leading up to the crash...a spike in swap for
example.  Maybe, if you can budget for it, query logging might give
some clues also.  Try increasing swap.

merlin

In response to

pgsql-performance by date

Next:From: Craig A. JamesDate: 2006-11-16 17:00:46
Subject: Re: Postgres server crash
Previous:From: Richard HuxtonDate: 2006-11-16 10:48:45
Subject: Re: Postgres server crash

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group