Thread: Recover postgres database
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
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
-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@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 helpNalini S. Nautiyal
Backup is with pg_dump -Ft command ie tar backup
----- Original Message -----
From: S Arvind <arvindwill@gmail.com>
Date: Tuesday, September 22, 2009 6:13 am
Subject: Re: [ADMIN] Recover postgres database
To: nalini <nalini@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
>
>
----- Original Message -----
From: S Arvind <arvindwill@gmail.com>
Date: Tuesday, September 22, 2009 6:13 am
Subject: Re: [ADMIN] Recover postgres database
To: nalini <nalini@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 <nalini@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
System Software Division
NIC HQ
New Delhi
Ph 24360324,24305121,24305131
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@nic.in> wrote:
Backup is with pg_dump -Ft command ie tar backup
----- Original Message -----
From: S Arvind <arvindwill@gmail.com>
Date: Tuesday, September 22, 2009 6:13 am
Subject: Re: [ADMIN] Recover postgres database
To: nalini <nalini@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 <nalini@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
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@gmail.com>
Date: Tuesday, September 22, 2009 11:25 pm
Subject: Re: [ADMIN] Recover postgres database
To: nalini <nalini@nic.in>
Cc: pgsql-admin <pgsql-admin@postgresql.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@nic.in> wrote:
> Backup is with pg_dump -Ft command ie tar backup>
>
> ----- Original Message -----
> From: S Arvind <arvindwill@gmail.com>
> Date: Tuesday, September 22, 2009 6:13 am
> Subject: Re: [ADMIN] Recover postgres database
> To: nalini <nalini@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 <nalini@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
>
>
Nalini S. Nautiyal
System Software Division
NIC HQ
New Delhi
Ph 24360324,24305121,24305131
System Software Division
NIC HQ
New Delhi
Ph 24360324,24305121,24305131