Re: Recover postgres database

Backup is with pg_dump -Ft command ie tar backup

----- Original Message -----
From: S Arvind <arvindwill(at)gmail(dot)com>
Date: Tuesday, September 22, 2009 6:13 am
Subject: Re: [ADMIN] Recover postgres database
To: nalini <nalini(at)nic(dot)in>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>

> 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(at)nic(dot)in> 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
>

>

Nalini S. Nautiyal
System Software Division
NIC HQ
New Delhi
Ph 24360324,24305121,24305131