public inbox for [email protected]
help / color / mirror / Atom feeddata_checksums = off
4+ messages / 4 participants
[nested] [flat]
* data_checksums = off
@ 2024-09-09 08:54 Wasim Devale <[email protected]>
2024-09-09 08:59 ` Re: data_checksums = off Michael Banck <[email protected]>
2024-09-09 08:59 ` Re: data_checksums = off Zaid Shabbir <[email protected]>
2024-09-09 09:00 ` Re: data_checksums = off Muhammad Usman Khan <[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:54 data_checksums = off Wasim Devale <[email protected]>
@ 2024-09-09 08:59 ` Michael Banck <[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:54 data_checksums = off Wasim Devale <[email protected]>
@ 2024-09-09 08:59 ` Zaid Shabbir <[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 08:54 data_checksums = off Wasim Devale <[email protected]>
@ 2024-09-09 09:00 ` Muhammad Usman Khan <[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