Re: How to check if Postgresql files are OK

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
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 06:28:14
Message-ID: CA+HiwqH=MdNpn0D+zjnZ3sOqhFB3d_tqexRtnhbaTwCz8U5P1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> It really depends. Having multiple backups over time will limit the
> risk that corruption gets propagated to a slave system. Also, there is
> a CRC on the WAL records which are shipped, which helps a bit, but there
> are still cases where corruption can get you. The best thing is to have
> frequent, tested, backups.
>

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?

--
Amit Langote

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jov 2013-05-28 06:41:43 Re: search_path for database vs user vs session
Previous Message Jov 2013-05-28 06:11:07 Re: How to check if Postgresql files are OK