Postgres Pro
Downloads
Home   >   mailing lists

Re: Can a broken Postgresql data directory be reconstructed without losing data? - Mailing list pgsql-general

From A A
Subject Re: Can a broken Postgresql data directory be reconstructed without losing data?
Date
Msg-id 335748960.475988.1523795697063@mail.yahoo.com
Whole thread Raw
In response to Re: Can a broken Postgresql data directory be reconstructed withoutlosing data?  (Ricardo Martin Gomez <rimartingomez@hotmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: rob stone
Date:
Subject: Re: cursor "x" does not exist
Next
From: Michael Paquier
Date:
Subject: Re: Can a broken Postgresql data directory be reconstructed withoutlosing data?