Postgres Pro
Downloads
Home   >   mailing lists

Re: data_checksums = off - Mailing list pgsql-admin

From Muhammad Usman Khan
Subject Re: data_checksums = off
Date
Msg-id CAPnRvGtC=KDaMnRknAdV1Jj7F_G=rPAPqrq4VdbGFnV1sK0eow@mail.gmail.com
Whole thread Raw
In response to data_checksums = off  (Wasim Devale <wasimd60@gmail.com>)
List pgsql-admin
Tree view

Hi,
You need to initialize new directory with cheksums

sudo -u postgres initdb -D /path/to/new/data/directory --data-checksums
Make sure to adjust permissions of data directory


On Mon, 9 Sept 2024 at 13:54, Wasim Devale <wasimd60@gmail.com> wrote:
Hi All

The data_checksums option is off in pg_settings and it is a preset option to do while doing initialisation of data directory. I can not use alter command any solutions to it?

Thanks,
Wasim

pgsql-admin by date:

Previous
From: Zaid Shabbir
Date:
Subject: Re: data_checksums = off
Next
From: vrms
Date:
Subject: Re: Basebackup