Home • Explore • Blog • CI
☰



postgresql
4th chunk of `doc/src/sgml/ref/initdb.sgml`
adefe36debfd75e5c12146170e0375e0df847916300b8d2c0000000100000fa1
 <literal>C</literal> or
        <literal>POSIX</literal>), then the default is <literal>UTF8</literal>
        for the ICU provider and <literal>SQL_ASCII</literal> for the
        <literal>libc</literal> provider.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-allow-group-access">
      <term><option>-g</option></term>
      <term><option>--allow-group-access</option></term>
      <listitem>
       <para>
        Allows users in the same group as the cluster owner to read all cluster
        files created by <command>initdb</command>.  This option is ignored
        on <productname>Windows</productname> as it does not support
        <acronym>POSIX</acronym>-style group permissions.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-icu-locale">
      <term><option>--icu-locale=<replaceable>locale</replaceable></option></term>
      <listitem>
       <para>
        Specifies the ICU locale when the ICU provider is used. Locale support
        is described in <xref linkend="locale"/>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-icu-rules">
      <term><option>--icu-rules=<replaceable>rules</replaceable></option></term>
      <listitem>
       <para>
        Specifies additional collation rules to customize the behavior of the
        default collation.  This is supported for ICU only.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-data-checksums">
      <term><option>-k</option></term>
      <term><option>--data-checksums</option></term>
      <listitem>
       <para>
        Use checksums on data pages to help detect corruption by the I/O
        system that would otherwise be silent.  This is enabled by default;
        use <xref linkend="app-initdb-no-data-checksums"/> to disable
        checksums.
       </para>

       <para>
        Enabling checksums
        might incur a small performance penalty. If set, checksums
        are calculated for all objects, in all databases. All checksum
        failures will be reported in the
        <link linkend="monitoring-pg-stat-database-view">
        <structname>pg_stat_database</structname></link> view.
        See <xref linkend="checksums" /> for details.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-locale">
      <term><option>--locale=<replaceable>locale</replaceable></option></term>
      <listitem>
       <para>
        Sets the default locale for the database cluster.  If this
        option is not specified, the locale is inherited from the
        environment that <command>initdb</command> runs in. Locale
        support is described in <xref linkend="locale"/>.
       </para>
       <para>
        If <option>--locale-provider</option> is <literal>builtin</literal>,
        <option>--locale</option> or <option>--builtin-locale</option> must be
        specified and set to <literal>C</literal>, <literal>C.UTF-8</literal>
        or <literal>PG_UNICODE_FAST</literal>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-lc-collate">
      <term><option>--lc-collate=<replaceable>locale</replaceable></option></term>
      <term><option>--lc-ctype=<replaceable>locale</replaceable></option></term>
      <term><option>--lc-messages=<replaceable>locale</replaceable></option></term>
      <term><option>--lc-monetary=<replaceable>locale</replaceable></option></term>
      <term><option>--lc-numeric=<replaceable>locale</replaceable></option></term>
      <term><option>--lc-time=<replaceable>locale</replaceable></option></term>

      <listitem>
       <para>
        Like <option>--locale</option>, but only sets the locale in
        the specified category.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-no-locale">
      <term><option>--no-locale</option></term>
      <listitem>
Title: initdb Options: ICU Locale, Checksums, and Locale Settings
Summary
This section details `initdb` options related to localization and data integrity. It covers specifying the ICU locale and collation rules, enabling or disabling data checksums for detecting I/O corruption, and setting the default locale for the database cluster. It also includes options for setting locale categories individually and disabling locale settings entirely.