Re: How to check if Postgresql files are OK
| От | Jov |
|---|---|
| Тема | Re: How to check if Postgresql files are OK |
| Дата | |
| Msg-id | CADyrUxPUG8XQP4v4TwV-Lwkk_u7O0BgXJ_-CJh+awqqtxCtj5A@mail.gmail.com обсуждение исходный текст |
| Ответ на | How to check if Postgresql files are OK (Nikhil G Daddikar <ngd@celoxis.com>) |
| Список | pgsql-general |
there is a wiki page aouble corruption detection：
but I think avoid corruption is more important and practical than try to check corruption：
Jov
blog: http:amutu.com/blog
2013/5/28 Nikhil G Daddikar <ngd@celoxis.com>
Folks,
I was using PostgreSQL 8.x in development environment when one day I started getting all kinds of low-level errors while running queries and eventually had to reinstall. Maybe it was salvageable but since it was a test database anyway it didn't matter.
We use PostgreSQL 9 on our production server and I was wondering if there there is a way to know when pages get corrupted. I see that there is some kind of checksum maintained from 9.3 but till then is there a way to be notified quickly when such a thing happens? I use a basebackup+rsync of WAL files as a disaster recovery solution. Will this be useful when such a scenario occurs?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: