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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-novice(at)postgresql(dot)org, Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
Subject: Re: Postgresql-8.4: File System Level Backup (& recovery failure)
Date: 2012-11-20 17:30:14
Message-ID: 9586.1353432614@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio-Sr 2012-11-20 21:36:05 Re: Postgresql-8.4: File System Level Backup (& recovery failure)
Previous Message Ennio-Sr 2012-11-20 17:12:27 Postgresql-8.4: File System Level Backup (& recovery failure)