reindexdb(1)

NAME

       reindexdb - reindex a PostgreSQL database

SYNOPSIS

       reindexdb  [ connection-option... ]  [ --table | -t table  ]  [ --index
       | -i index  ]  [ dbname ]

       reindexdb [ connection-option... ]  [ --all | -a ]

       reindexdb [ connection-option... ]  [ --system | -s ]  [ dbname ]

DESCRIPTION

       reindexdb is a utility for rebuilding indexes in a PostgreSQL database.

       reindexdb  is  a  wrapper  around the SQL command REINDEX [reindex(5)].
       There is no effective difference between reindexing databases via  this
       utility and via other methods for accessing the server.

OPTIONS

       reindexdb accepts the following command-line arguments:

       -a

       --all  Reindex all databases.

       -s

       --system
              Reindex database's system catalogs.

       -t table

       --table table
              Reindex table only.

       -i index

       --index index
              Recreate index only.

       [-d] dbname

       [--dbname] dbname
              Specifies  the name of the database to be reindexed.  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 reindexdb  generates  and  sends  to  the
              server.

       -q

       --quiet
              Do not display a response.

       reindexdb 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 password prompt.

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 REINDEX [reindex(5)] 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

       reindexdb 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 reindex the database test:

       $ reindexdb test

       To reindex the table foo and the index bar in a database named abcd:

       $ reindexdb --table foo --index bar abcd

SEE ALSO

       REINDEX [reindex(5)]

Application                       2008-06-08                      REINDEXDB(1)