Re: Postgres server crash

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/15/06, Craig A. James <cjames@xxxxxxxxxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux