Обсуждение: 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