table of contents
REINDEXDB(1) | PostgreSQL 12.22 Documentation | REINDEXDB(1) |
NAME¶
reindexdb - reindex a PostgreSQL database
SYNOPSIS¶
reindexdb [connection-option...] [option...] [ -S | --schema schema ]... [ -t | --table table ]... [ -i | --index index ]... [dbname]
reindexdb [connection-option...] [option...] -a | --all
reindexdb [connection-option...] [option...] -s | --system [dbname]
DESCRIPTION¶
reindexdb is a utility for rebuilding indexes in a PostgreSQL database.
reindexdb is a wrapper around the SQL command REINDEX(7). 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
-i index
--index=index
-q
--quiet
-s
--system
-S schema
--schema=schema
-t table
--table=table
-v
--verbose
-V
--version
-?
--help
reindexdb also accepts the following command-line arguments for connection parameters:
-h host
--host=host
-p port
--port=port
-U username
--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 33.14).
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.
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 Section 33.15 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¶
2024 | PostgreSQL 12.22 |