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: Zaid Shabbir <zaidshabbir@gmail.com>
Date: Mon, 9 Sep 2024 13:59:58 +0500
Message-ID: 
 <CABCJe_VVrmOJTR2SXEOZ3P1=f9YGEsUHRiu44V8wgxkRzUUd6A@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="000000000000fe13210621abfbb2"
Archived-At: 
 <https://www.postgresql.org/message-id/CABCJe_VVrmOJTR2SXEOZ3P1%3Df9YGEsUHRiu44V8wgxkRzUUd6A%40mail.gmail.com>
Precedence: bulk

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

Hello,

You can use pg_checksum to enable or disable data_checksums after the
cluster initialization.

For reference please view the official PostgreSQL guide.

https://www.postgresql.org/docs/current/app-pgchecksums.html

Regards,
Zaid

On Mon, Sep 9, 2024 at 1:54=E2=80=AFPM Wasim Devale <wasimd60@gmail.com> wr=
ote:

> 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
>

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

<div dir=3D"ltr">Hello,<div><br></div><div>You can use pg_checksum to enabl=
e or disable data_checksums after the cluster initialization.</div><div><br=
></div><div>For reference please view the official PostgreSQL guide.</div><=
div><br></div><div><a href=3D"https://www.postgresql.org/docs/current/app-p=
gchecksums.html">https://www.postgresql.org/docs/current/app-pgchecksums.ht=
ml</a><br></div><div><br></div><div>Regards,</div><div>Zaid</div></div><br>=
<div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, Se=
p 9, 2024 at 1:54=E2=80=AFPM Wasim Devale &lt;<a href=3D"mailto:wasimd60@gm=
ail.com">wasimd60@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-l=
eft-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div d=
ir=3D"auto">Hi All<div dir=3D"auto"><br></div><div dir=3D"auto">The data_ch=
ecksums 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 sol=
utions to it?</div><div dir=3D"auto"><br></div><div dir=3D"auto">Thanks,</d=
iv><div dir=3D"auto">Wasim</div></div>
</blockquote></div>

--000000000000fe13210621abfbb2--