HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to install Postgresql on Ubuntu from PPA with data-checksums enabled?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
postgresqlinstallenabledubuntuwithchecksumshowfromdatappa

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#171258, answer score: 5

Revisions (0)

No revisions yet.