Re: pg_restore validation?

On 09/02/2011 15:10, u235sentinel wrote:
> 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.

Well, pg_dump returns 0 on success, and error messages on standard error
on failure.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie