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@gmail.com
>> <mailto:u235sentinel@gmail.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@iol.ie