Re: Can a broken Postgresql data directory be reconstructed without losing data?

Поиск
Список
Период
Сортировка
От A A
Тема Re: Can a broken Postgresql data directory be reconstructed without losing data?
Дата
Msg-id 335748960.475988.1523795697063@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Can a broken Postgresql data directory be reconstructed withoutlosing data?  (Ricardo Martin Gomez <rimartingomez@hotmail.com>)
Список pgsql-general
Well this doesn't address the question at all.

On Sunday, April 15, 2018, 1:44:00 PM GMT+2, Ricardo Martin Gomez <rimartingomez@hotmail.com> wrote:


You must to restore a database from a backup.

Regards.


From: A A <fellah.tech@yahoo.com>
Sent: Sunday, April 15, 2018 5:25:05 AM
To: pgsql-general@lists.postgresql.org
Subject: Can a broken Postgresql data directory be reconstructed without losing data?
 

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 по дате отправления:

Предыдущее
От: rob stone
Дата:
Сообщение: Re: cursor "x" does not exist
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Can a broken Postgresql data directory be reconstructed withoutlosing data?