MIME-Version: 1.0
References: 
 <CAB5fag7fm34nqYLjPdQcGn=V_SApwZVnXv-gU=XWY9_7aKLLxA@mail.gmail.com>
In-Reply-To: 
 <CAB5fag7fm34nqYLjPdQcGn=V_SApwZVnXv-gU=XWY9_7aKLLxA@mail.gmail.com>
From: Muhammad Usman Khan <usman.k@bitnine.net>
Date: Mon, 9 Sep 2024 14:00:33 +0500
Message-ID: 
 <CAPnRvGtC=KDaMnRknAdV1Jj7F_G=rPAPqrq4VdbGFnV1sK0eow@mail.gmail.com>
Subject: Re: data_checksums = off
To: Wasim Devale <wasimd60@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ff80360621abfdda"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPnRvGtC%3DKDaMnRknAdV1Jj7F_G%3DrPAPqrq4VdbGFnV1sK0eow%40mail.gmail.com>
Precedence: bulk

--000000000000ff80360621abfdda
Content-Type: text/plain; charset="UTF-8"

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
>

--000000000000ff80360621abfdda
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><br clear=3D"all"><div><div dir=3D"ltr" class=3D"gmail_sig=
nature" data-smartmail=3D"gmail_signature"><div dir=3D"ltr"><span></span><d=
iv>Hi,<br>You need to initialize new directory with cheksums<br><br>sudo -u=
 postgres initdb -D /path/to/new/data/directory --data-checksums<br>Make=C2=
=A0sure to adjust permissions of data directory</div></div></div></div><br>=
</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">=
On Mon, 9 Sept 2024 at 13:54, Wasim Devale &lt;<a href=3D"mailto:wasimd60@g=
mail.com">wasimd60@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"auto">Hi All<div dir=3D"auto"><br><=
/div><div dir=3D"auto">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?</div><div dir=3D"auto"><br>=
</div><div dir=3D"auto">Thanks,</div><div dir=3D"auto">Wasim</div></div>
</blockquote></div>

--000000000000ff80360621abfdda--