Thread: Permanent fatal errors

Permanent fatal errors

From
"Josh Berkus"
Date:
Folks,

My development database died without a recent backup (it's adevelopment, and not a production machine, so no automated
backup:-p).  I can't make Postgres run again without an initdb, which will wipeout my data.  Is there any way I can
retrievethe schema and data fromthe raw files, which are intact?
 

Thanks, Josh

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


Re: Permanent fatal errors

From
Tom Lane
Date:
"Josh Berkus" <josh@agliodbs.com> writes:
> My development database died without a recent backup (it's a
>  development, and not a production machine, so no automated backup :-p
>  ).  I can't make Postgres run again without an initdb, which will wipe
>  out my data.  Is there any way I can retrieve the schema and data from
>  the raw files, which are intact?

I'm confused.  Your machine died, but you still have the files?
What exactly have you lost?
        regards, tom lane