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
>