Home Explore Blog CI



postgresql

3rd chunk of `doc/src/sgml/ref/reindexdb.sgml`
f6c46327ebb05055c77908e76c16f2875033795942287a080000000100000f8e
 progress messages.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-s</option></term>
      <term><option>--system</option></term>
      <listitem>
       <para>
        Reindex database's system catalogs only.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-S <replaceable class="parameter">schema</replaceable></option></term>
      <term><option>--schema=<replaceable class="parameter">schema</replaceable></option></term>
      <listitem>
       <para>
        Reindex <replaceable class="parameter">schema</replaceable> only.
        Multiple schemas can be reindexed by writing multiple
        <option>-S</option> switches.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-t <replaceable class="parameter">table</replaceable></option></term>
      <term><option>--table=<replaceable class="parameter">table</replaceable></option></term>
      <listitem>
       <para>
        Reindex <replaceable class="parameter">table</replaceable> only.
        Multiple tables can be reindexed by writing multiple
        <option>-t</option> switches.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>--tablespace=<replaceable class="parameter">tablespace</replaceable></option></term>
      <listitem>
       <para>
        Specifies the tablespace where indexes are rebuilt. (This name is
        processed as a double-quoted identifier.)
       </para>
      </listitem>
     </varlistentry>

    <varlistentry>
     <term><option>-v</option></term>
     <term><option>--verbose</option></term>
     <listitem>
      <para>
       Print detailed information during processing.
      </para>
     </listitem>
    </varlistentry>

    <varlistentry>
      <term><option>-V</option></term>
      <term><option>--version</option></term>
      <listitem>
       <para>
       Print the <application>reindexdb</application> version and exit.
       </para>
      </listitem>
    </varlistentry>

    <varlistentry>
      <term><option>-?</option></term>
      <term><option>--help</option></term>
      <listitem>
      <para>
      Show help about <application>reindexdb</application> command line
      arguments, and exit.
      </para>
      </listitem>
    </varlistentry>

   </variablelist>

   </para>

   <para>
    <application>reindexdb</application> also accepts
    the following command-line arguments for connection parameters:

    <variablelist>
     <varlistentry>
      <term><option>-h <replaceable class="parameter">host</replaceable></option></term>
      <term><option>--host=<replaceable class="parameter">host</replaceable></option></term>
      <listitem>
       <para>
        Specifies the host name of the machine on which the server is
        running.  If the value begins with a slash, it is used as the
        directory for the Unix domain socket.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-p <replaceable class="parameter">port</replaceable></option></term>
      <term><option>--port=<replaceable class="parameter">port</replaceable></option></term>
      <listitem>
       <para>
        Specifies the TCP port or local Unix domain socket file
        extension on which the server
        is listening for connections.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-U <replaceable class="parameter">username</replaceable></option></term>
      <term><option>--username=<replaceable class="parameter">username</replaceable></option></term>
      <listitem>
       <para>
        User name to connect as.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-w</option></term>
      <term><option>--no-password</option></term>
      <listitem>
       <para>
        Never issue a password prompt.  If the server requires

Title: reindexdb Additional Options and Connection Parameters
Summary
This section continues detailing the command-line options for reindexdb, including options for reindexing specific tables or tablespaces, printing detailed information, displaying the version, and showing help. It also describes connection parameters such as host, port, and username for connecting to the PostgreSQL server.