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
