Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> As I am not sure to have stopped the postgres server *before* making the
> original copy to the backup dir, is there any chance for me to:
> 1. ascertain that the backup was made while postgres was running and
> therefore it's completely useless;
Use pg_controldata to print out the contents of the pg_control file as
extracted from the backup. If it doesn't say the cluster state is "shut
down", then you've probably got an inconsistent filesystem backup.
> 2. make sure that failure to recover has nothing to do with the version
> of postgresql-client.
Shouldn't ...
regards, tom lane