Hi,
On Mon, Sep 09, 2024 at 02:24:04PM +0530, Wasim Devale wrote:
> 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?
You need to shut down the instance and then run
pg_checksums --enable -D <data directory>
Checksums cannot be enabled while the instance is online and the above
needs to rewrite every block so it can take a while on larger instances.
Michael