Re: 8.1.3 Crash/Corruption Problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: 8.1.3 Crash/Corruption Problem
Date
Msg-id 11772.1168277119@sss.pgh.pa.us
Whole thread Raw
In response to 8.1.3 Crash/Corruption Problem  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-admin
"Chris Hoover" <revoohc@gmail.com> writes:
> Over the weekend, I suffered from major database corruption on my
> 8.1.3database.  Fortunetly, this was my development/non-production box
> so I did
> not have to spend my entire weekend getting it back online, but I did spend
> a major portion of it.  I ended up having to do a pitr recovery of the
> system.  I don't understand what happened to the system.  Please help
> explain what happened.  Also, would there have been another option to get
> the system back online w/o the full recovery?

This looks like a problem we fixed in 8.1.6 ... consider updating.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Chris Hoover"
Date:
Subject: 8.1.3 Crash/Corruption Problem
Next
From: "Shahryar G. Hashemi"
Date:
Subject: ERROR: permission denied for language c