On Monday, April 3, 2017, Ertan Küçükoğlu <
ertan.kucukoglu@1nar.com.tr> wrote:
- If I setup a new PostgreSQL server using identical binaries as the crashed
one, and copy rescued data directory onto that new server data directory,
overwriting new system data directory when server is down. Will that work
assuming recovered data is structurally fine?
If you can copy over the last versions of the WAL and data files (including non-default tablespaces) (and ideally configuration files) and point the same binaries to those it will work in theory.
If that method works, how can
I test that database files are fine and there is no problem with them?
Performing a full pg_dump on the database/cluster is the only routine I can think of - but my experience here is limited.
David J.