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)

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


              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 vacuumdb to prompt for a password before connecting  to  a

              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




       PGUSER Default connection parameters

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

       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 in 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                       2009-12-09                       VACUUMDB(1)

Time taken: 0.00070 seconds

Created with the man page lookup class by Andrew Collington,