Re: Does PostgreSQL check database integrity at startup?
| От | Pavel Stehule |
|---|---|
| Тема | Re: Does PostgreSQL check database integrity at startup? |
| Дата | |
| Msg-id | CAFj8pRD+FStVDHV19nsbRVSkdk_0bKX=guFW3BD68Z0t5igsVQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Does PostgreSQL check database integrity at startup? (Martin Marques <martin.marques@2ndquadrant.com>) |
| Ответы |
Re: Does PostgreSQL check database integrity at startup?
|
| Список | pgsql-hackers |
2017-12-26 14:44 GMT+01:00 Martin Marques <martin.marques@2ndquadrant.com>:
El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió:
> Recently I had a problem with a base file with size 0 in a standby server.
>
> This raised one question: does PostgreSQL (9.6.6) check base integrity
> at startup?
>
> At least if there are 0 byte size files in base dir? Or CRC? Something?
Yes it has CRC check, but only if you initialize the cluster with
--data-checksums, and there's a price to pay in performance.
It has CRC check, but it is used in runtime - when data are necessary
So Postgres usually check nothing on start - few system tables and indexes
Regards
Pavel
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления: