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