Re: Total crash of my db-server

hi tom,

ok, I understand this.

But: There is ONLY postgres running on this particular
machine. And it's mostly when backup (dumpall) and/or
vacuuming/reindexing is going on.

In my opinion, postgresql does something on my machine
that leads to these complete system lockups.

--

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(at)topconcepts(dot)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: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ian Barwick" <barwick(at)gmx(dot)net>
Cc: "Henrik Steffen" <steffen(at)city-map(dot)de>; <pgsql-general(at)postgresql(dot)org>;
"Justin Clift" <justin(at)postgresql(dot)org>
Sent: Sunday, December 15, 2002 5:29 PM
Subject: Re: [GENERAL] Total crash of my db-server

> >> This *really* sounds like you have a system wide problem, not just a
> >> PostgreSQL problem.
> >>
> >> Can't imagine how moving to MySQL will help with that. ;-)
>
> Actually, moving to MySQL will make it worse. We can say with
> confidence that a system lockup is not Postgres' fault because Postgres
> does not (and will not) run as root. I'm not sure whether MySQL *must*
> be root, but that seems to be a pretty common way of setting it up ...
> and when you do that, you can't entirely exclude it from consideration
> when you're looking at problems that would require root privileges to
> cause.
>
> > Addtionally, have you considered the possibility of a hardware
> > problem?
>
> I tend to agree with Ian on that --- it sounds more like flaky hardware
> than anything else. Time for memtest86 and some disk testing too.
>
> regards, tom lane