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

You must to restore a database from a backup.

Regards.

Obtener Outlook para Android<https://aka.ms/ghei36>

________________________________
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