Environment Variable for --data-checksum during initdb

On 9/5/19 12:25 PM, Ray Cote wrote:

I'm trying to remember what environment variable can be set
--data-checksum before running postgresql-setup initdb. I know I've seen
it but it escapes my recall at the moment.

AFAIK it does not exist and do I not see anything here:

https://doxygen.postgresql.org/initdb_8c.html

The PostgreSQL documentation has a nice page of environment variables
for when PostgreSQL is running, but I'm not finding the variable to set
during the initdb phase.

Any help to jog my memory greatly appreciated.
--Ray

--
Adrian Klaver
adrian.klaver@aklaver.com

On Thu, Sep 5, 2019 at 3:25 PM Ray Cote <rgacote@appropriatesolutions.com>
wrote:

I'm trying to remember what environment variable can be set

--data-checksum before running postgresql-setup initdb. I know I've seen it
but it escapes my recall at the moment.

The PostgreSQL documentation has a nice page of environment variables for

when PostgreSQL is running, but I'm not finding the variable to set during
the initdb phase.

Any help to jog my memory greatly appreciated.
--Ray

Found my answer:
There are three variables you can set, one for init, one for upgrading, and
one for debug messaging.
These can be set when calling postgresql-nn-setup.
No documentation regarding these in the PostgreSQL documentation.
I'm assuming this feature is part of the RHEL/CentOS deploy configuration.

Environment:
PGSETUP_INITDB_OPTIONS Options carried by this variable are passed to
subsequent call of `initdb` binary (see man
initdb(1)). This variable is used also during
'upgrade' mode because the new cluster is
actually
re-initialized from the old one.
PGSETUP_PGUPGRADE_OPTIONS Options in this variable are passed next to the
subsequent call of `pg_upgrade`. For more info
about possible options please look at man
pg_upgrade(1).
PGSETUP_DEBUG Set to '1' if you want to see debugging output.

On 9/7/19 5:32 AM, Ray Cote wrote:

On Thu, Sep 5, 2019 at 3:25 PM Ray Cote
<rgacote@appropriatesolutions.com
<mailto:rgacote@appropriatesolutions.com>> wrote:

I'm trying to remember what environment variable can be set

--data-checksum before running postgresql-setup initdb. I know I've seen
it but it escapes my recall at the moment.

The PostgreSQL documentation has a nice page of environment variables

for when PostgreSQL is running, but I'm not finding the variable to set
during the initdb phase.

Any help to jog my memory greatly appreciated.
--Ray

Found my answer:
There are three variables you can set, one for init, one for upgrading,
and one for debug messaging.
These can be set when calling postgresql-nn-setup.
No documentation regarding these in the PostgreSQL documentation.
I'm assuming this feature is part of the RHEL/CentOS deploy configuration.

I believe so as there is no mention of the below in the Postgres source.

Environment:
  PGSETUP_INITDB_OPTIONS     Options carried by this variable are passed to
                             subsequent call of `initdb` binary (see man
                             initdb(1)).  This variable is used also during
                             'upgrade' mode because the new cluster is
actually
                             re-initialized from the old one.
  PGSETUP_PGUPGRADE_OPTIONS  Options in this variable are passed next
to the
                             subsequent call of `pg_upgrade`.  For more
info
                             about possible options please look at man
                             pg_upgrade(1).
  PGSETUP_DEBUG              Set to '1' if you want to see debugging
output.

--
Adrian Klaver
adrian.klaver@aklaver.com