3

We are currently installing Postgresql from the PostgreSQL apt repository. Is there some way to get "apt-get install postgresql-9.6" to use the --data-checksums option when setting up the cluster?

Or do we need to install Postgresql differently?

David Tinker
  • 471
  • 1
  • 3
  • 9

2 Answers2

5

If you do not want to install and drop the cluster on Debian and related, you could:

  • Install postgresql-common;
  • Edit the /etc/postgresql-common/createcluster.conf file to allow the use of the --data-checksums option;
  • Install postgresql-9.6.
KookieMonster
  • 2,037
  • 19
  • 18
3

When you use apt-get, it creates a cluster without data checksum. All you have to do is to drop the newly created cluster:

pg_dropcluster 9.6 main

and create a new one with that option

pg_createcluster 9.6 <clusterName> <Youroptions (datachecksum for example)>

Or you can change the file /usr/share/postgresql-common/createcluster.conf to put your data-checksum option there.

Michael Green
  • 25,255
  • 13
  • 54
  • 100
Arkhena
  • 1,610
  • 10
  • 15