| From: | Lee Harr <missive(at)frontiernet(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Total crash of my db-server |
| Date: | 2002-12-15 22:25:01 |
| Message-ID: | ativfs$1768$1@news.hub.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In article <00d601c2a443$7b7b7dd0$7100a8c0(at)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Brown | 2002-12-15 23:20:37 | Re: Total crash of my db-server |
| Previous Message | Andreas Schlegel | 2002-12-15 21:45:49 | Index and performance |