Skip site navigation (1) Skip section navigation (2)

Re: Recover postgres database

From: S Arvind <arvindwill(at)gmail(dot)com>
To: nalini <nalini(at)nic(dot)in>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Recover postgres database
Date: 2009-09-23 06:23:28
Message-ID: abf9211d0909222323s3d101662qa21f808604817697@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>
>
>

In response to

Responses

pgsql-admin by date

Next:From: naliniDate: 2009-09-23 06:35:23
Subject: Re: Recover postgres database
Previous:From: naliniDate: 2009-09-23 04:20:19
Subject: Re: Recover postgres database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group