Re: How to check if Postgresql files are OK - Mailing list pgsql-general

From Amit Langote
Subject Re: How to check if Postgresql files are OK
Date
Msg-id CA+HiwqH=MdNpn0D+zjnZ3sOqhFB3d_tqexRtnhbaTwCz8U5P1g@mail.gmail.com
Whole thread Raw
In response to Re: How to check if Postgresql files are OK  (Stephen Frost <sfrost@snowman.net>)
Responses Re: How to check if Postgresql files are OK  (Stephen Frost <sfrost@snowman.net>)
List 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


pgsql-general by date:

Previous
From: Jov
Date:
Subject: Re: How to check if Postgresql files are OK
Next
From: Jov
Date:
Subject: Re: search_path for database vs user vs session