Re: Restoring database from files on disk

From: Richard Huxton <dev(at)archonet(dot)com>
To: veejar <veejar(dot)net(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restoring database from files on disk
Date: 2006-12-01 10:34:27
Message-ID: 45700533.8060701@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

veejar wrote:
> Hello!
>
> I had problems with my HDD and i have lost many files. From my pgsql
> database files I have only "base"-folder. In this folder one is
> important database:
> base/45325101

> How to correct this one database?

You can't. You need all the files in data/ - recover the whole cluster
and then dump the one you're interested in.

It that's impossible, there are some tools that can dump on-disk
structures, but they're not designed for recovering a database and
you're unlikely to get all your data back that way anyway.

Use your last backup - it'll save you time.
--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-12-01 10:37:41 Re: COPY FROM and NULL AS does not work
Previous Message Teodor Sigaev 2006-12-01 10:32:04 Re: Tsearch2 - Error using tsquery object in GROUP BBY