Postgres Pro
Downloads
Home   >   mailing lists

Re: Does PostgreSQL check database integrity at startup? - Mailing list pgsql-hackers

From Martin Marques
Subject Re: Does PostgreSQL check database integrity at startup?
Date
Msg-id 2736ceab-73ad-489d-d455-43d38b90cc60@2ndquadrant.com
Whole thread Raw
In response to Does PostgreSQL check database integrity at startup?  (Edson Carlos Ericksson Richter <richter@simkorp.com.br>)
Responses Re: Does PostgreSQL check database integrity at startup?
List pgsql-hackers
Tree view 
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.


-- 
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] [PATCH] Lockable views
Next
From: Lelisa Diriba
Date:
Subject: Ethiopian calendar year(DATE TYPE) are different from the Gregoriancalendar year