Re: [ADMIN] Recover postgres database

2009-09-22 Thread nalini
Yes there are bad sectors . I tried to restore backup on a local server but the dump fails with the error somenumber.dat missing - Original Message - From: S Arvind Date: Tuesday, September 22, 2009 11:25 pm Subject: Re: [ADMIN] Recover postgres database To: nalini Cc: pgsql-admin

Re: [ADMIN] Recover postgres database

2009-09-22 Thread S Arvind
3 am > Subject: Re: [ADMIN] Recover postgres database > To: nalini > Cc: pgsql-admin > > > 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

Re: [ADMIN] Recover postgres database

2009-09-22 Thread nalini
Backup is with pg_dump -Ft command ie tar backup - Original Message - From: S Arvind Date: Tuesday, September 22, 2009 6:13 am Subject: Re: [ADMIN] Recover postgres database To: nalini Cc: pgsql-admin > Is the backup is made by pg_dump or copying the entire data folder? > >

Re: [ADMIN] Recover postgres database

2009-09-22 Thread S Arvind
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 wrote: > I am unable to recover my data due hard disk

[ADMIN] Recover postgres database

2009-09-22 Thread nalini
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 m