Re: Postgresql-8.4: File System Level Backup (& recovery failure)

Ennio-Sr <nasr.laili@tin.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