reindexdb(1)

REINDEXDB(1)     PostgreSQL Client Applications      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  Post-
     greSQL database.

     reindexdb is a wrapper around the SQL command REINDEX [rein-
     dex(5)].   There is no effective difference between reindex-
     ing 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

Application          Last change: 2008-01-03                    1

REINDEXDB(1)     PostgreSQL Client Applications      REINDEXDB(1)

          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 connection 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
          extension  on which the server is listening for connec-
          tions.

     -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  environment  variables supported by libpq (see in

Application          Last change: 2008-01-03                    2

REINDEXDB(1)     PostgreSQL Client Applications      REINDEXDB(1)

     the documentation).

DIAGNOSTICS

     In case of difficulty, see REINDEX [reindex(5)] and  psql(1)
     for  discussions  of  potential problems and error messages.
     The database server must be running at  the  targeted  host.
     Also,  any default connection settings and environment vari-
     ables used by the libpq front-end library will apply.

NOTES

     reindexdb might need to connect several times to  the  Post-
     greSQL  server,  asking for a password each time. It is con-
     venient 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          Last change: 2008-01-03                    3