Restoring database from files on disk

Поиск
Список
Период
Сортировка
От veejar
Тема Restoring database from files on disk
Дата
Msg-id a4c4d7e50612010224r147c06d1t8ae5bbca94729cb@mail.gmail.com
обсуждение исходный текст
Ответы Re: Restoring database from files on disk  (Richard Huxton <dev@archonet.com>)
Список 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?

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Separation of clients' data within a database
Следующее
От: "Willy-Bas Loos"
Дата:
Сообщение: Re: named cache