public inbox for [email protected]  

help / color / mirror / Atom feed

data_checksums = off
4+ messages / 4 participants
[nested] [flat]

* data_checksums = off
@ 2024-09-09 08:54  Wasim Devale <[email protected]>
  0 siblings, 3 replies; 4+ messages in thread

From: Wasim Devale @ 2024-09-09 08:54 UTC (permalink / raw)
  To: Pgsql-admin <[email protected]>; pgsql-admin

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


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: data_checksums = off
@ 2024-09-09 08:59  Michael Banck <[email protected]>
  parent: Wasim Devale <[email protected]>
  2 siblings, 0 replies; 4+ messages in thread

From: Michael Banck @ 2024-09-09 08:59 UTC (permalink / raw)
  To: Wasim Devale <[email protected]>; +Cc: Pgsql-admin <[email protected]>; pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: data_checksums = off
@ 2024-09-09 08:59  Zaid Shabbir <[email protected]>
  parent: Wasim Devale <[email protected]>
  2 siblings, 0 replies; 4+ messages in thread

From: Zaid Shabbir @ 2024-09-09 08:59 UTC (permalink / raw)
  To: Wasim Devale <[email protected]>; +Cc: Pgsql-admin <[email protected]>; pgsql-admin

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 PM Wasim Devale <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: data_checksums = off
@ 2024-09-09 09:00  Muhammad Usman Khan <[email protected]>
  parent: Wasim Devale <[email protected]>
  2 siblings, 0 replies; 4+ messages in thread

From: Muhammad Usman Khan @ 2024-09-09 09:00 UTC (permalink / raw)
  To: Wasim Devale <[email protected]>; +Cc: Pgsql-admin <[email protected]>; 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 <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 4+ messages in thread

end of thread, other threads:[~2024-09-09 09:00 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-09-09 08:54 data_checksums = off Wasim Devale <[email protected]>
2024-09-09 08:59 ` Michael Banck <[email protected]>
2024-09-09 08:59 ` Zaid Shabbir <[email protected]>
2024-09-09 09:00 ` Muhammad Usman Khan <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox