Filesystem crash - corupted database

Поиск
Список
Период
Сортировка
От Martin Bednář
Тема Filesystem crash - corupted database
Дата
Msg-id 46FA2D80.4060803@triax.cz
обсуждение исходный текст
Ответы Re: Filesystem crash - corupted database  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: Filesystem crash - corupted database  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
Hi,

It's possible to extract data directly from data files ?
I have two tablespaces one for data and one for indexes.
After filesystem crash I lost my /var/lib/postgresql/data folder :( All
data is in /lost+found :(, I found folders with data and index tablespe
that looks ok.
It's possible to directly access these files and extract data as CSV for
example ?
Or it's possible "mount" these tablespaces to new database instance ?

Thnx for advice
Bedy

btw: I know - restore from backups, but DB is too big, and I have
backups 6days ago.


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

Предыдущее
От: "Ashish Karalkar"
Дата:
Сообщение: pgpoolAdmin:No such file or directory in /var/www/html/pgpoolAdmin-1.0.0/libs/Smarty.class.php on line 1258
Следующее
От: "Moiz Kothari"
Дата:
Сообщение: Re: pgpoolAdmin:No such file or directory in /var/www/html/pgpoolAdmin-1.0.0/libs/Smarty.class.php on line 1258