Hope there is bad sector. Did u checked restoring the backup DB to ur local server?
On Wed, Sep 23, 2009 at 9:50 AM, nalini <nal...@nic.in> wrote: > Backup is with pg_dump -Ft command ie tar backup > > > ----- Original Message ----- > From: S Arvind <arvindw...@gmail.com> > Date: Tuesday, September 22, 2009 6:13 am > Subject: Re: [ADMIN] Recover postgres database > To: nalini <nal...@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 <nal...@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 > > >