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-22 13:12:23
Message-ID: abf9211d0909220612o4dbcad73o90024113f60e1336@mail.gmail.com (view raw or flat)
Thread:
Lists: 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 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
>
>

In response to

Responses

pgsql-admin by date

Next:From: edinoDate: 2009-09-22 15:16:46
Subject: could not send data to client: Broken pipe
Previous:From: Maja MassariniDate: 2009-09-22 12:04:49
Subject: could not open relation with OID 2610

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