Re: Data Recovery

It's postgresl 8.01 on AMD 64 Suse 9.2.  The database didn't dump
succesfully for several days in a row so the backup is corrupted also.

The controller card crashed and we think caused data corruption.  I
rebooted the system the following day, and it came back up, but all
was not well, pg_dump all failed that day, and the following day.

Thanks,

Alex Turner
netEconomist


On Wed, 16 Mar 2005 12:14:03 -0800, Lonni J Friedman <netllama@gmail.com> wrote:
> On Wed, 16 Mar 2005 14:43:09 -0500, Alex Turner <armtuk@gmail.com> wrote:
> > I have a crashed database fileset, and I'm wondering if there is any
> > way to recover the data from a specific table.  I know which table got
> > corrupted, and it's not the table I am trying to recover.
> >
> > I know this is a little vague, but I'm not really sure what
> > information would be pertinent..
>
> Crashed how exactly?   If you can explain what led to the current
> state, we could likely assist in recovering.  Which version of
> PostgreSQL are you running, and on which OS?
>
> I'm guessing that you don't have recent reliable backups of this data?
>
>
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> L. Friedman                                    netllama@gmail.com
> LlamaLand                       http://netllama.linux-sxs.org
>