NAME
reindexdb - reindex a PostgreSQL database
SYNOPSIS
reindexdb [connection-option...] [option...] [ -S | --schemaschema ]... [ -t | --tabletable ]... [ -i | --indexindex ]... [ -s | --system ] [dbname | -a | --all]
DESCRIPTION
reindexdb is a utility for rebuilding indexes in a PostgreSQL database.
reindexdb is a wrapper around the SQL command REINDEX. 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
--concurrently
[-d]dbname [--dbname=]dbname
-e --echo
-iindex --index=index
-jnjobs --jobs=njobs
reindexdb will open njobs connections to the database, so make sure your max_connections setting is high enough to accommodate all connections.
Note that this option is incompatible with the --system option.
-q --quiet
-s --system
-Sschema --schema=schema
-ttable --table=table
--tablespace=tablespace
-v --verbose
-V --version
-? --help
reindexdb also accepts the following command-line arguments for connection parameters:
-hhost --host=host
-pport --port=port
-Uusername --username=username
-w --no-password
-W --password
This option is never essential, since reindexdb will automatically prompt for a password if the server demands password authentication. However, reindexdb 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.
--maintenance-db=dbname
ENVIRONMENT
PGDATABASE PGHOST PGPORT PGUSER
PG_COLOR
This utility, like most other PostgreSQL utilities, also uses the environment variables supported by libpq (see Section 32.15).
DIAGNOSTICS
In case of difficulty, see REINDEX(7) 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 variables used by the libpq front-end library will apply.
EXAMPLES
To reindex the database test:
$ \nreindexdb testTo reindex the table foo and the index bar in a database named abcd:
$ \nreindexdb --table=foo --index=bar abcdSEE ALSO
REINDEX(7)