Re: I/O error on data file, can't run backup

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: I/O error on data file, can't run backup
Date: 2011-10-05 22:43:31
Message-ID: 201110060043.31181.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 6. October 2011 00.17.38 Steve Crawford wrote:
> I'm thinking perhaps a funky memory problem - you are having odd crashes
> after all.

I've been thinking about the memory myself, but it passes memtest86plus with
flying colors. Or at least it did the last time I checked which is a few months
ago.

The problems got a lot better after I replaced a monster Radeon XFX video card
with a very basic fanless NVidia card (with the added bonus that I can now
actually watch Flash videos in full screen), which may point to overheating
issues.

In other news: I discovered that injecting `date +%u` into the backup file name
at an appropriate place will number it by weekday, which is great for keeping
daily backups for a week.

regards, Leif.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-10-05 23:34:49 Selecting All Columns Associated With Maximum Value of One Column
Previous Message Phil Couling 2011-10-05 22:29:57 Re: gaps/overlaps in a time table : current and previous row question