Home Explore Blog CI



postgresql

3rd chunk of `doc/src/sgml/ref/pg_dumpall.sgml`
1c2d5d490f7108b26d6dcc46e0fbecc536b621beb1068a9f0000000100000fba
 The directory
           will have database <type>oid</type> as its name.
          </para>
         </listitem>
        </varlistentry>

        <varlistentry>
         <term><literal>p</literal></term>
         <term><literal>plain</literal></term>
         <listitem>
          <para>
           Output a plain-text SQL script file (the default).
          </para>
         </listitem>
        </varlistentry>

        <varlistentry>
         <term><literal>c</literal></term>
         <term><literal>custom</literal></term>
         <listitem>
          <para>
           Output a custom-format archive for each database,
           suitable for input into pg_restore. The archive
           will be named <filename>dboid.dmp</filename> where <type>dboid</type> is the
           <type>oid</type> of the database.
          </para>
         </listitem>
        </varlistentry>

         <varlistentry>
         <term><literal>t</literal></term>
         <term><literal>tar</literal></term>
         <listitem>
          <para>
           Output a tar-format archive for each database,
           suitable for input into pg_restore. The archive
           will be named <filename>dboid.tar</filename> where <type>dboid</type> is the
           <type>oid</type> of the database.
          </para>
         </listitem>
        </varlistentry>

        </variablelist>

       Note: see <xref linkend="app-pgdump"/> for details
       of how the various non plain text archives work.

        </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-g</option></term>
      <term><option>--globals-only</option></term>
      <listitem>
       <para>
        Dump only global objects (roles and tablespaces), no databases.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-O</option></term>
      <term><option>--no-owner</option></term>
      <listitem>
       <para>
        Do not output commands to set
        ownership of objects to match the original database.
        By default, <application>pg_dumpall</application> issues
        <command>ALTER OWNER</command> or
        <command>SET SESSION AUTHORIZATION</command>
        statements to set ownership of created schema elements.
        These statements
        will fail when the script is run unless it is started by a superuser
        (or the same user that owns all of the objects in the script).
        To make a script that can be restored by any user, but will give
        that user ownership of all the objects, specify <option>-O</option>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-r</option></term>
      <term><option>--roles-only</option></term>
      <listitem>
       <para>
        Dump only roles, no databases or tablespaces.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-s</option></term>
      <term><option>--schema-only</option></term>
      <listitem>
       <para>
        Dump only the object definitions (schema), not data.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-S <replaceable class="parameter">username</replaceable></option></term>
      <term><option>--superuser=<replaceable class="parameter">username</replaceable></option></term>
      <listitem>
       <para>
        Specify the superuser user name to use when disabling triggers.
        This is relevant only if <option>--disable-triggers</option> is used.
        (Usually, it's better to leave this out, and instead start the
        resulting script as superuser.)
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-t</option></term>
      <term><option>--tablespaces-only</option></term>
      <listitem>
       <para>
        Dump only tablespaces, no databases or roles.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry>
      <term><option>-v</option></term>

Title: pg_dumpall Options: Dump Formats, Global Objects, Ownership, and More
Summary
This section continues detailing pg_dumpall options, focusing on dump formats (directory, plain, custom, tar), and options for dumping only global objects (-g/--globals-only), roles (-r/--roles-only), tablespaces (-t/--tablespaces-only) or schema (-s/--schema-only). It also explains how to exclude ownership settings from the dump (-O/--no-owner) and specify a superuser username (-S/--superuser) for disabling triggers, which is relevant when using --disable-triggers.