Restoring database from files on disk

From: veejar <veejar(dot)net(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Restoring database from files on disk
Date: 2006-12-01 10:24:54
Message-ID: a4c4d7e50612010224r147c06d1t8ae5bbca94729cb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

I reinstall my postgresql-server.
I have created new database with same name and have copied all files
from my old folder to new folder. I have successful connect to this
database, but when I try to browse my tables, I see error message:

ERROR: could not access status of transaction 18651428
DETAIL: could not open file "/var/db/pgsql/pg_clog/0011": No such
file or directory

How to correct this one database?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2006-12-01 10:27:25 Re: named cache
Previous Message Richard Huxton 2006-12-01 10:22:15 Re: Separation of clients' data within a database