Re: Total crash of my db-server

the whole computer crashes.

it'S mostly during dumpalls (backup) and/or vacuuming
or reindexing...

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "Lee Harr" <missive@frontiernet.net>
To: <pgsql-general@postgresql.org>
Sent: Sunday, December 15, 2002 11:25 PM
Subject: Re: [GENERAL] Total crash of my db-server


> 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.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster