Re: PostgreSQL 9.6.1 - Windows 64bit - HDD crash due to power outage

On Monday, April 3, 2017, Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)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.