VACUUMDB(1)             PostgreSQL Client Applications             VACUUMDB(1)


       vacuumdb - garbage-collect and analyze a PostgreSQL database


       vacuumdb  [  connection-option...  ]   [   [  --full ]  [ -f ]  ]  [  [
       --verbose ]  [ -v ]  ]  [  [ --analyze ]  [ -z ]  ]  [ --table | -t ta-
        [ ( column [,...] ) ]
        ]  [ dbname ]

       vacuumdb  [  connection-options...  ]   [   [  --all ]  [ -a ]  ]  [  [
       --full ]  [ -f ]  ]  [  [ --verbose ]  [ -v ]  ]  [  [ --analyze  ]   [
       -z ]  ]


       vacuumdb  is  a  utility  for cleaning a PostgreSQL database.  vacuumdb
       will also generate internal statistics used  by  the  PostgreSQL  query

       vacuumdb is a wrapper around the SQL command VACUUM [vacuum(7)].  There
       is no effective difference between vacuuming databases via this utility
       and via other methods for accessing the server.


       vacuumdb accepts the following command-line arguments:


       --all  Vacuum all databases.

       [-d] dbname

       [--dbname] dbname
              Specifies  the  name  of the database to be cleaned or analyzed.
              If this is not specified and -a (or  --all)  is  not  used,  the
              database  name is read from the environment variable PGDATABASE.
              If that is not set, the user name specified for  the  connection
              is used.


       --echo Echo  the  commands  that  vacuumdb  generates  and sends to the


       --full Perform ‘‘full’’ vacuuming.


              Do not display a response.

       -t table [ (column [,...]) ]

       --table table [ (column [,...]) ]
              Clean or analyze table only.  Column names may be specified only
              in conjunction with the --analyze option.

              Tip:  If  you  specify  columns, you probably have to escape the
              parentheses from the shell. (See examples below.)


              Print detailed information during processing.


              Calculate statistics for use by the optimizer.

       vacuumdb also accepts the following command-line arguments for  connec-
       tion parameters:

       -h host

       --host host
              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.

       -p port

       --port port
              Specifies  the  TCP port or local Unix domain socket file exten-
              sion on which the server is listening for connections.

       -U username

       --username username
              User name to connect as


              Force password prompt.





       PGUSER Default connection parameters


       In case of difficulty, see VACUUM [vacuum(7)] and psql(1)  for  discus-
       sions  of  potential  problems and error messages.  The database server
       must be running at the targeted host. Also, any default connection set-
       tings  and  environment  variables  used by the libpq front-end library
       will apply.


       vacuumdb might need to connect several times to the PostgreSQL  server,
       asking  for  a password each time. It is convenient to have a ~/.pgpass
       file in such cases. See the documentation for more information.


       To clean the database test:

       $ vacuumdb test

       To clean and analyze for the optimizer a database named bigdb:

       $ vacuumdb --analyze bigdb

       To clean a single table foo in a database named xyzzy,  and  analyze  a
       single column bar of the table for the optimizer:

       $ vacuumdb --analyze --verbose --table â€â€™foo(bar)â€â€™ xyzzy


       VACUUM [vacuum(7)]

Application                       2005-01-17                       VACUUMDB(1)

Man(1) output converted with man2html