Environment Variable for --data-checksum during initdb

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Environment Variable for --data-checksum during initdb

Ray Cote
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

Reply | Threaded
Open this post in threaded view
|

Re: Environment Variable for --data-checksum during initdb

Adrian Klaver-4
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
[hidden email]


Reply | Threaded
Open this post in threaded view
|

Re: Environment Variable for --data-checksum during initdb

Ray Cote
In reply to this post by Ray Cote
On Thu, Sep 5, 2019 at 3:25 PM Ray Cote <[hidden email]> 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.
Reply | Threaded
Open this post in threaded view
|

Re: Environment Variable for --data-checksum during initdb

Adrian Klaver-4
On 9/7/19 5:32 AM, Ray Cote wrote:

> On Thu, Sep 5, 2019 at 3:25 PM Ray Cote
> <[hidden email]
> <mailto:[hidden email]>> 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
[hidden email]