Home • Explore • Blog • CI
☰



postgresql
5th chunk of `doc/src/sgml/ref/initdb.sgml`
234e5d34a657d43dc7a2cf5a44b9f14c7925b2cce3e739730000000100000fa3
 <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>
       <para>
        Equivalent to <option>--locale=C</option>.
       </para>
      </listitem>
     </varlistentry>

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

     <varlistentry id="app-initdb-option-locale-provider">
      <term><option>--locale-provider={<literal>builtin</literal>|<literal>libc</literal>|<literal>icu</literal>}</option></term>
      <listitem>
       <para>
        This option sets the locale provider for databases created in the new
        cluster.  It can be overridden in the <command>CREATE
        DATABASE</command> command when new databases are subsequently
        created.  The default is <literal>libc</literal> (see <xref
        linkend="locale-providers"/>).
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-no-data-checksums">
      <term><option>--no-data-checksums</option></term>
      <listitem>
       <para>
        Do not enable data checksums.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-pwfile">
      <term><option>--pwfile=<replaceable>filename</replaceable></option></term>
      <listitem>
       <para>
        Makes <command>initdb</command> read the bootstrap superuser's password
        from a file.  The first line of the file is taken as the password.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-text-search-config">
      <term><option>-T <replaceable>config</replaceable></option></term>
      <term><option>--text-search-config=<replaceable>config</replaceable></option></term>
      <listitem>
       <para>
        Sets the default text search configuration.
        See <xref linkend="guc-default-text-search-config"/> for further information.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-username">
      <term><option>-U <replaceable class="parameter">username</replaceable></option></term>
      <term><option>--username=<replaceable class="parameter">username</replaceable></option></term>
      <listitem>
       <para>
        Sets the user name of the
        <glossterm linkend="glossary-bootstrap-superuser">bootstrap superuser</glossterm>.
        This defaults to the name of the operating-system user running
        <command>initdb</command>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="app-initdb-option-pwprompt">
      <term><option>-W</option></term>
      <term><option>--pwprompt</option></term>
      <listitem>
       <para>
        Makes <command>initdb</command> prompt for a password
        to give the bootstrap superuser. If you don't plan on using password
Title: initdb Options: Locale Providers, Checksums, and Superuser Settings
Summary
This section details more `initdb` options, including disabling locale settings or setting them to 'C', specifying a locale for the builtin provider, and choosing a locale provider ('builtin', 'libc', or 'icu'). It also covers disabling data checksums, reading the superuser's password from a file, setting the default text search configuration, specifying the bootstrap superuser's username, and prompting for the superuser password.