Can a broken Postgresql data directory be reconstructed withoutlosing data?

Поиск
Список
Период
Сортировка
От A A
Тема Can a broken Postgresql data directory be reconstructed withoutlosing data?
Дата
Msg-id 22260152.420560.1523780705996@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Can a broken Postgresql data directory be reconstructed withoutlosing data?  (Ricardo Martin Gomez <rimartingomez@hotmail.com>)
Re: Can a broken Postgresql data directory be reconstructed withoutlosing data?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general

I'm trying to restore a database from a broken data directory that have lost many of its files accidentally.

I have tried unsuccessfully to install new instance of the same Postgresql version and then copy (with overwrite) the broken datadir to the new one. here the remaining datadir that I'm working on :

   |-base  |---1  |---16384  |---17950  |---19621  |---pgsql_tmp  |-global  |-pg_multixact  |---members  |---offsets  |-pg_notify  |-pg_stat_tmp  |-pg_tblspc  |-pg_xlog  |---archive_status

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Regex on field value
Следующее
От: Ricardo Martin Gomez
Дата:
Сообщение: Re: hardcode password in connect string