Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Data checksum with pg upgradecluster - Mailing list pgsql-general

From Dan
Subject [GENERAL] Data checksum with pg upgradecluster
Date
Msg-id CAK00fOJMgQU7qgpSCH=uffrbhAcd_Hv6+xf5+-iHRsOvoJeDbQ@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Data checksum with pg upgradecluster  ("Karsten Hilbert" <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view 
Hi,

I'm updating my database from 9.4 to 9.6 (Debian Jessie to Stretch). I
think that it is a good opportunity to turn on data checksum.

I don't have experience with cluster creation or moving a DB to a new cluster.

I'll use pg_upgradecluster, but I don't see any option to turn of data checksum.

I took a look to the pg_upgradecluster script. I think that it invokes
pg_createcluster. Therefore I think that I should get data checksums
if I add in the file /etc/postgresql-common/createcluster.conf the
following line:
initdb_options = '--data-checksums'

Is this correct?

Thanks,
Daniel

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)
Next
From: "Karsten Hilbert"
Date:
Subject: Re: [GENERAL] Data checksum with pg upgradecluster