Обсуждение: Environment Variable for --data-checksum during initdb
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
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.
>
> 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.
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