Re: pg_restore validation?

[u235sentinel <u235sentinel@xxxxxxxxx>]

On 02/09/2011 07:52 AM, Vick Khera wrote:

On Tue, Feb 8, 2011 at 8:06 PM, u235sentinel <u235sentinel@xxxxxxxxx> 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!