Re: Does PostgreSQL check database integrity at startup?

From: Martin Marques <martin(dot)marques(at)2ndquadrant(dot)com>
To: Edson Carlos Ericksson Richter <richter(at)simkorp(dot)com(dot)br>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Does PostgreSQL check database integrity at startup?
Date: 2017-12-26 13:44:40
Message-ID: 2736ceab-73ad-489d-d455-43d38b90cc60@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2017-12-26 14:25:47 Re: Does PostgreSQL check database integrity at startup?
Previous Message Timo Myyrä 2017-12-26 13:14:55 Re: Oracle to postgres migration