Re: Recover postgres database

> Backup is with pg_dump -Ft command ie tar backup

>
>
> ----- Original Message -----
> From: S Arvind <arvindwill@gmail.com>
> Date: Tuesday, September 22, 2009 6:13 am
> Subject: Re: [ADMIN] Recover postgres database
> To: nalini <nalini@nic.in>
> Cc: pgsql-admin <pgsql-admin@postgresql.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@nic.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

>
>