Re: [ADMIN] Recover postgres database

2009-09-23 Thread S Arvind
, 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

Re: [ADMIN] Recover postgres database

2009-09-23 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 arvindw...@gmail.com Date: Tuesday, September 22, 2009 11:25 pm Subject: Re: [ADMIN] Recover postgres database To: nalini

[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

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 nal...@nic.in wrote: I am unable to recover my data

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 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