Re: pg_restore validation? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: pg_restore validation?
Date
Msg-id 4D52AFA7.3030204@iol.ie
Whole thread Raw
In response to Re: pg_restore validation?  (u235sentinel <u235sentinel@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: u235sentinel
Date:
Subject: Re: pg_restore validation?
Next
From: Robert Fitzpatrick
Date:
Subject: Re: plperl.dll on windows with postgresql 9.0.3