Re: Total crash of my db-server - Mailing list pgsql-general

From Lee Harr
Subject Re: Total crash of my db-server
Date
Msg-id ativfs$1768$1@news.hub.org
Whole thread Raw
In response to Total crash of my db-server  ("Henrik Steffen" <steffen@city-map.de>)
List pgsql-general
In article <00d601c2a443$7b7b7dd0$7100a8c0@henrik>, "Henrik Steffen" wrote:
>

> sometimes I experience a total crash of my
> db-server while e.g. doing automated maintainance tasks:
>

The computer crashes or just the database?
It is not clear from your description.

> Always complete crashes... only reset helped.
>

reset postgres? or are you resetting the computer?


> Most crashes occur while maintainance tasks.
> However, there are some other crashes, too.
>

Is there any commonality between crashes? Are the
others maybe during daily/ weekly OS reporting?
(Generally, heavy disk activity)


> We are running some mysql-servers here, too, and I
> more and more often try to imagine to move my whole
> system to a mysql-server... my collegues NEVER have
> had such trouble with their mysql-servers yet....
>
> Do you have any hints for me? What can I do? My last
> choice would be to move to mysql, but I am almost
> desperate....
>


You are running mysql on the same machine? Or are these
separate systems running mysql?

My first reaction is "hardware trouble" but without
more specifics it is tough to make a diagnosis. If
you have a spare box, that might be a quick way to
see if the problem is hardware related.



pgsql-general by date:

Previous
From: Andreas Schlegel
Date:
Subject: Index and performance
Next
From: Kevin Brown
Date:
Subject: Re: Total crash of my db-server