2017-12-26 14:44 GMT+01:00 Martin Marques <martin.marq...@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 > >
