Re: How to check if Postgresql files are OK

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Amit Langote <amitlangote09(at)gmail(dot)com>
Cc: Nikhil G Daddikar <ngd(at)celoxis(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to check if Postgresql files are OK
Date: 2013-05-28 12:37:23
Message-ID: 20130528123723.GB8597@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Amit Langote (amitlangote09(at)gmail(dot)com) wrote:
> How does one validate a backup? Is there any generally practiced way
> of doing that? Or what do you mean when you say "tested" backups?

You restore from it and then query the restored database for expected
contents, at least.

Thanks,

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2013-05-28 13:30:33 Re: search_path for database vs user vs session
Previous Message Michael Paquier 2013-05-28 11:31:34 Re: Success stories of PostgreSQL implementations in different companies