| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Michael Guerin" <guerin(at)rentec(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: database corruption |
| Date: | 2004-06-11 21:38:13 |
| Message-ID: | 1086989893.31155.5.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Fri, 2004-06-11 at 14:16, Michael Guerin wrote:
> Hi,
>
> We recently switch over from Solaris to Linux and we've been
> experiencing a couple database corruptions problems. We're using the
> 2.6 kernel and a XFS file system, in case there are any known problems
> with this setup.
>
> It's my understanding that these errors are typically b/c of hardware
> problems, so we're in the process of checking the disk. However, are
> there other things that I should look to find out what's going on? The
> table that was corrupted earlier this week was dropped and recreated,
> but it was corrupted again sometime last night. The table is pretty
> active, about 10GB are inserted and deleted every day.
Be sure and test your memory too. And if you have a hardware RAID
controller, sometimes they can be slightly broken and cause random
corruption.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | M. Bastin | 2004-06-11 22:32:08 | Re: Character encoding in database dumps |
| Previous Message | Michael Guerin | 2004-06-11 20:16:30 | database corruption |