Re: How to check if Postgresql files are OK

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: How to check if Postgresql files are OK
Дата
Msg-id CA+HiwqH=MdNpn0D+zjnZ3sOqhFB3d_tqexRtnhbaTwCz8U5P1g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to check if Postgresql files are OK  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: How to check if Postgresql files are OK  (Stephen Frost <sfrost@snowman.net>)
Список 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 по дате отправления:

Предыдущее
От: Jov
Дата:
Сообщение: Re: How to check if Postgresql files are OK
Следующее
От: Jov
Дата:
Сообщение: Re: search_path for database vs user vs session