Home • Explore • Blog • CI
☰



postgresql
2nd chunk of `doc/src/sgml/vacuumlo.sgml`
fb2fde94754f06c07bf67722fab4a7b782cc25d995b97f4200000001000008f1
 <term><option>--verbose</option></term>
    <listitem>
     <para>Write a lot of progress messages.</para>
    </listitem>
   </varlistentry>

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

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

  <para>
   <application>vacuumlo</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>Database server's host.</para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><option>-p <replaceable>port</replaceable></option></term>
    <term><option>--port=<replaceable class="parameter">port</replaceable></option></term>
    <listitem>
     <para>Database server's port.</para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><option>-U <replaceable>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 password
      authentication and a password is not available by other means
      such as a <filename>.pgpass</filename> file, the connection
      attempt will fail.  This option can be useful in batch jobs and
      scripts where no user is present to enter a password.
     </para>
    </listitem>
   </varlistentry>

   <varlistentry>
    <term><option>-W</option></term>
    <term><option>--password</option></term>
Title: vacuumlo Command-Line Options and Connection Parameters
Summary
This section details the command-line options and connection parameters for the vacuumlo utility in PostgreSQL. It includes options for verbose output, version display, and help information. Connection parameters allow users to specify the host, port, username, and password handling for database access. Notable options include --verbose for detailed progress messages, --version to display the tool's version, and --help for command-line argument information. Connection parameters cover host, port, username, and password-related settings, including options for never prompting for a password or always prompting for one.