initdb --data-checksums

Hi Matt,

On 09. Nov, 2020, at 18:00, Matt Zagrabelny <mzagrabe@d.umn.edu> wrote:

Hello,

I see the --data-checksums option for initdb. Is it possible to use --data-checksums after the cluster has been initialized? I'm guessing "not", but thought I'd ask.

I'm running v12 on Debian.

Thanks for any help!

indeed, it is. Have a look at:

https://www.postgresql.org/docs/12/app-pgchecksums.html

Make sure the database is cleanly shut down before doing it.

Cheers,
Paul

On Mon, Nov 09, 2020 at 06:03:43PM +0100, Paul Förster wrote:

indeed, it is. Have a look at:

https://www.postgresql.org/docs/12/app-pgchecksums.html

Make sure the database is cleanly shut down before doing it.

This tool is really useful with upgrades after pg_upgrade. Please
note that there is a --progress option, so you can basically know how
long it is going to take until completion.
--
Michael