Re: pg_restore validation?

On 02/09/2011 07:52 AM, Vick Khera wrote:
> On Tue, Feb 8, 2011 at 8:06 PM, u235sentinel <u235sentinel(at)gmail(dot)com
> <mailto:u235sentinel(at)gmail(dot)com>> wrote:
>
> Is there a way we can validate a postgers backup? (short of
> restoring it somewhere)
>
>
> Define "validate" for your purpose. Once you do that, then you can
> come up with the procedure for accomplishing your validation. Hint:
> simply restoring it somewhere may not be sufficient...
>
For validate what I'm looking to do is provide either some log or
message provided by postgres that will alert us when/if the backup did
'not' complete successfully. So I guess it's more of a pg_dump
validation I'm looking into.

I've been googling and found pg_rman which doesn't sound like what I'm
looking for. It has a validate function but their documentation is a
little light.

Thanks!