On 02/09/2011 07:52 AM, Vick Khera wrote:
On Tue, Feb 8, 2011 at 8:06 PM, u235sentinel <u235senti...@gmail.com
<mailto:u235senti...@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.
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!