Data checksum with pg upgradecluster

From: Dan <ganchya(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Data checksum with pg upgradecluster
Date: 2017-08-06 12:15:27
Message-ID: CAK00fOJMgQU7qgpSCH=uffrbhAcd_Hv6+xf5+-iHRsOvoJeDbQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2017-08-06 12:43:35 Re: Data checksum with pg upgradecluster
Previous Message David G. Johnston 2017-08-06 07:46:55 PostgreSQL with PowerBuilder, and Identity keys (serials)