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

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgresql-8.4: File System Level Backup (& recovery failure)
Date: 2012-11-20 21:36:05
Message-ID: 20121120213605.GA5008@deby.ei.hnet
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-novice

* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [201112, 12:30]:
> Ennio-Sr <nasr(dot)laili(at)tin(dot)it> writes:
> > As I am not sure to have stopped the postgres server *before* making the
>
> 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.
>

Mmh... it does say 'shut down'; as to the other items to my
un-experienced eyes they look so similar to the result I get on a bare
'new' (empty) cluster just created in a different dir...
Does the 'shut down' verdict means there are other ways to attempt
before giving up the challenge?

Thank you so much for your help.
Best regards, ennio

--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2012-11-20 22:04:22 Re: Postgresql-8.4: File System Level Backup (& recovery failure)
Previous Message Tom Lane 2012-11-20 17:30:14 Re: Postgresql-8.4: File System Level Backup (& recovery failure)