| From: | "Willy-Bas Loos" <willybas(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | stability issues |
| Date: | 2007-09-18 10:04:55 |
| Message-ID: | 1dd6057e0709180304o5698926fy26c53bc3e1400cfb@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I'm running a PostgreSQL 8.1.9 server on Debian etch (default installation,
w/ PostGIS from Debian repositories).
The machine has double Xeon 5130, 4 GB of DDR2 ECC Reg. RAM and a
two-sata-disc Raid 0 cluster. I don't know the brand of the memory nor the
HDDs. The Riad controller is a 3Ware 8006-2.
Lately i've been confronted by some failures in several PostgreSQL clusters.
3 weeks ago a cluster crashed when i was reindexing it, beond my repair.
Last week we've been getting Toast warnings and shared index problems on
another cluster. I solved the shared index issue, but the Toast trouble
remained, in more than one database on that cluster. I dumped the databases,
created another cluster and shut the troubled one down. (problems were
solved).
I've asked our provider to do a filesystem check, (e2fsck -f /dev/sda1)
which indicated that "there's nothing wrong with the filesystem".
This doesn't feel right.
Is there anything else i should check?
thx,
WBL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ow Mun Heng | 2007-09-18 10:05:47 | Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER |
| Previous Message | Bill Moran | 2007-09-18 10:01:26 | Re: For index bloat: VACUUM ANALYZE vs REINDEX/CLUSTER |