Linux.pl
Opcje wyszukiwania podręcznika man:
Lista stron man zaczynających się od znaku:
A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z   ALPHA   NUM   OTHER   ALL
VACUUMDB(1)             PostgreSQL Client Applications             VACUUMDB(1)

NAME
       vacuumdb - garbage-collect and analyze a PostgreSQL database

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

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

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

       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.

OPTIONS
       vacuumdb accepts the following command-line arguments:

       -a

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

       -e

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

       -f

       --full Perform ``full'' vacuuming.

       -q

       --quiet
              Do not display progress messages.

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

       --table table [ (column [,...]) ]
              Clean or analyze table only.  Column names can 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.)

       -v

       --verbose
              Print detailed information during processing.

       -z

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

       -W

       --password
              Force vacuumdb to prompt for a password before connecting  to  a
              database.

              This  option  is  never essential, since vacuumdb will automati-
              cally prompt for a  password  if  the  server  demands  password
              authentication.   However,  vacuumdb  will  waste  a  connection
              attempt finding out that the server wants a password.   In  some
              cases  it  is  worth  typing  -W  to  avoid the extra connection
              attempt.

ENVIRONMENT
       PGDATABASE

       PGHOST

       PGPORT

       PGUSER Default connection parameters

       This utility, like most other PostgreSQL utilities, also uses the envi-
       ronment variables supported by libpq (see in the documentation).

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

NOTES
       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 in the documentation for more information.

EXAMPLES
       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

SEE ALSO
       VACUUM [vacuum(7)]

Application                       2009-12-09                       VACUUMDB(1)

Time taken: 0.00011 seconds


Created with the man page lookup class by Andrew Collington, php@amnuts.com