Re: Recommended way to enable data-checksums on Centos 7?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
Cc: 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 22:15:11
Message-ID: da02ff07-3eef-b0d5-ba84-57924abebb50@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/25/19 2:05 PM, Ken Tanzer wrote:
> On Mon, Feb 25, 2019 at 1:35 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> If I am following correctly, what you want is something
> like the below from pg_ctl, correct?:
>
> https://www.postgresql.org/docs/11/app-pg-ctl.html
>
> pg_ctl init[db] [-D datadir] [-s] [-o initdb-options]
>
> ...
>
> >      > 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?
> >      >
> >
>
>
> Something like that "-o" option would be nice.  But regardless of the
> solution, and given how simple & streamlined the install path/directions
> are, it seems to me to make sense to have some way of doing this that
> doesn't involve having to read through the setup script.  That could be

From looking at the script running:

postgresql-11-setup --help

will get you that information.

> a simpler option, or it could just be a footnote on the install page,
> next to the initdb command, something like:

That would be nice, unfortunately I am not the person to get that done.
Your best bet on this would be to file an issue here:

https://yum.postgresql.org/contact.php

You will need a community account to do this.

>
> Optionally initialize the database and enable automatic start:
>   /usr/pgsql-11/bin/postgresql-11-setup initdb (*)
>   systemctl enable postgresql-11
>   systemctl start postgresql-11
>
> (*) Some options for initializing the database can't be changed later
> (except by wiping out and reinitializing).  You can specify options by
> running export PGSETUP_INITDB_OPTIONS="<your options>" before running
> this command.  See
> <https://www.postgresql.org/docs/current/app-initdb.html> for options.
> Cheers,
> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2019-02-25 22:45:28 Re: 9.0 standby - could not open file global/XXXXX
Previous Message Ken Tanzer 2019-02-25 22:05:33 Re: Recommended way to enable data-checksums on Centos 7?