From: | A A <fellah(dot)tech(at)yahoo(dot)com> |
---|---|
To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Ricardo Martin Gomez <rimartingomez(at)hotmail(dot)com> |
Subject: | Re: Can a broken Postgresql data directory be reconstructed without losing data? |
Date: | 2018-04-15 12:34:57 |
Message-ID: | 335748960.475988.1523795697063@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)hotmail(dot)com> wrote:
You must to restore a database from a backup.
Regards.
Obtener Outlook para Android
From: A A <fellah(dot)tech(at)yahoo(dot)com>
Sent: Sunday, April 15, 2018 5:25:05 AM
To: pgsql-general(at)lists(dot)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-04-15 12:48:34 | Re: Can a broken Postgresql data directory be reconstructed without losing data? |
Previous Message | rob stone | 2018-04-15 12:15:23 | Re: cursor "x" does not exist |