Re: Recover postgres database

[S Arvind <arvindwill@xxxxxxxxx>]

Is the backup is made by pg_dump or copying the entire data folder?

-Arvind S


"Many of lifes failure are people who did not realize how close they were to success when they gave up."

-Thomas Edison

On Tue, Sep 22, 2009 at 5:01 PM, nalini <nalini@xxxxxx> wrote:

I am unable to recover my data due hard disk errors. Although I am able to start the postgres service.

even pgfsck fails after some. Any hope of recovery? Please let me know any thing that can be done.

 

The server was located at user site and even the backups are not getting restored. I have more than one backup and none of them are working. They fail with the message somenumber.dat header missing or file missing.

 

please help

 

 

Nalini S. Nautiyal