Lost main database directory but not tablespace holding the database - how to recover?

From: Geir Pedersen <geirp6(at)start(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Lost main database directory but not tablespace holding the database - how to recover?
Date: 2005-07-16 07:07:51
Message-ID: 1121497671.42d8b2470bce4@epost.start.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My main disk for Postgresql crashed but I still have the database as it was
stored on a tablespace on another disk. Now the problem is how to recover from
this situation.

What I have tried is to restore the database from a backup from a few houres
before the crash and then replacing the directory within the pgsql-data/base
directory holding the database with the version of the database from the
uncorrupted disk. When I try to access the database I get

ERROR: could not access status of transaction 1827968
DETAIL: could not open file "/home/software/postgres/DATA/pg_clog/0001": No
such file or directory

How can I solve this inconsistency and recover the database? :)

Thanks!

Geir.

-------------------------------------------------------------------------
Start.no tilbyr nå raskere bredbånd til lavere pris.
Sjekk http://www.start.no/bredband/ for mer informasjon

Browse pgsql-general by date

  From Date Subject
Next Message Jiří Němec 2005-07-16 07:19:08 PostgreSQL select
Previous Message Berend Tober 2005-07-16 02:04:07 Re: How to create unique constraint on NULL columns