Re: data_checksums = off

From: Muhammad Usman Khan <usman(dot)k(at)bitnine(dot)net>
To: Wasim Devale <wasimd60(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: data_checksums = off
Date: 2024-09-09 09:00:33
Message-ID: CAPnRvGtC=KDaMnRknAdV1Jj7F_G=rPAPqrq4VdbGFnV1sK0eow@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)gmail(dot)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
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message vrms 2024-09-09 19:21:46 Re: Basebackup
Previous Message Zaid Shabbir 2024-09-09 08:59:58 Re: data_checksums = off