From: | nalini <nalini(at)nic(dot)in> |
---|---|
To: | S Arvind <arvindwill(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Recover postgres database |
Date: | 2009-09-23 06:35:23 |
Message-ID: | 6f0c683c3aac0f5a.4ab95f3b@nic.in |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 <arvindwill(at)gmail(dot)com>
Date: Tuesday, September 22, 2009 11:25 pm
Subject: Re: [ADMIN] Recover postgres database
To: nalini <nalini(at)nic(dot)in>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
> 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 <nalini(at)nic(dot)in> wrote:
> Backup is with pg_dump -Ft command ie tar backup
>
>
> ----- Original Message -----
> From: S Arvind <arvindwill(at)gmail(dot)com>
> Date: Tuesday, September 22, 2009 6:13 am
> Subject: Re: [ADMIN] Recover postgres database
> To: nalini <nalini(at)nic(dot)in>
> Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)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(at)nic(dot)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
>
>
>
Nalini S. Nautiyal
System Software Division
NIC HQ
New Delhi
Ph 24360324,24305121,24305131
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2009-09-23 11:21:31 | recovery is stuck when children are not processing SIGQUIT from previous crash |
Previous Message | S Arvind | 2009-09-23 06:23:28 | Re: Recover postgres database |