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

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>
Subject: Can a broken Postgresql data directory be reconstructed without losing data?
Date: 2018-04-15 08:25:05
Message-ID: 22260152.420560.1523780705996@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ricardo Martin Gomez 2018-04-15 11:35:41 Re: hardcode password in connect string
Previous Message Adrian Klaver 2018-04-14 21:12:25 Re: Regex on field value