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@xxxxxxxxx
<mailto: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.
Well, pg_dump returns 0 on success, and error messages on standard error
on failure.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general