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