From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>, PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Recommended way to enable data-checksums on Centos 7? |
Date: | 2019-02-25 01:03:53 |
Message-ID: | eaa07805-60aa-180c-7be6-94f4a0ad933d@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2/24/19 2:39 PM, Ken Tanzer wrote:
> Hi. I recently installed PG 11.2 on Centos 7, following the excellent
> directions at
.
>
> I wanted to enable data-checksums. I at first tried appending
> --data-checksums to the doc-specified command:
>
> /usr/pgsql-11/bin/postgresql-11-setup initdb --data-checksums
>
> but that did not work. After a glance at that script, I was able to do
> it with:
>
> export PGSETUP_INITDB_OPTIONS="--data-checksums"
> /usr/pgsql-11/bin/postgresql-11-setup initdb
>
> I'm just wondering if there is a more preferred way to do this, and/or
> any particular reason you can't pass options to initdb? Also, since the
You can pass options to initdb:
https://www.postgresql.org/docs/11/app-initdb.html
It seems you cannot pass them to the script postgresql-11-setup. That
would be a question for the packagers:
https://yum.postgresql.org/contact.php
Or you could just use the initdb program directly instead of going
through the script. The caveat being whether that would interfere with
what the script does?
> checksums are good for data integrity, and can only be done at init
> time, I wonder if it's worth adding a note about it to that
> documentation page?
>
> Thanks.
>
> Ken
>
>
> --
> AGENCY Software
> A Free Software data system
> By and for non-profits
> /http://agency-software.org//
> /https://demo.agency-software.org/client/
> ken(dot)tanzer(at)agency-software(dot)org <mailto:ken(dot)tanzer(at)agency-software(dot)org>
> (253) 245-3801
>
> Subscribe to the mailing list
> <mailto:agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
> learn more about AGENCY or
> follow the discussion.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Boris Sagadin | 2019-02-25 06:52:37 | Logical replication very slow |
Previous Message | Stefan Keller | 2019-02-25 00:09:05 | Property Graph Query Language proposed for SQL:2020 |