OS Manuals

/usr/lib/postgresql/14/bin/reindexdb

commercial-spilo-4-fips compat package

From commercial-spilo-4-fips-compat 4.1.2-r9 (enterprise-packages), captured 2026-11-08 by running reindexdb --help (exit 0). permalink

reindexdb reindexes a PostgreSQL database.

Usage:
  reindexdb [OPTION]... [DBNAME]

Options:
  -a, --all                    reindex all databases
      --concurrently           reindex concurrently
  -d, --dbname=DBNAME          database to reindex
  -e, --echo                   show the commands being sent to the server
  -i, --index=INDEX            recreate specific index(es) only
  -j, --jobs=NUM               use this many concurrent connections to reindex
  -q, --quiet                  don't write any messages
  -s, --system                 reindex system catalogs only
  -S, --schema=SCHEMA          reindex specific schema(s) only
  -t, --table=TABLE            reindex specific table(s) only
      --tablespace=TABLESPACE  tablespace where indexes are rebuilt
  -v, --verbose                write a lot of output
  -V, --version                output version information, then exit
  -?, --help                   show this help, then exit

Connection options:
  -h, --host=HOSTNAME          database server host or socket directory
  -p, --port=PORT              database server port
  -U, --username=USERNAME      user name to connect as
  -w, --no-password            never prompt for password
  -W, --password               force password prompt
  --maintenance-db=DBNAME      alternate maintenance database

Read the description of the SQL command REINDEX for details.

Report bugs to <pgsql-bugs@lists.postgresql.org>.
PostgreSQL home page: <https://www.postgresql.org/>
Options (20)
OptionDescriptionSource
-a, --allreindex all databaseshelp
--concurrentlyreindex concurrentlyhelp
-d, --dbname DBNAMEdatabase to reindexhelp
-e, --echoshow the commands being sent to the serverhelp
-i, --index INDEXrecreate specific index(es) onlyhelp
-j, --jobs NUMuse this many concurrent connections to reindexhelp
-q, --quietdon't write any messageshelp
-s, --systemreindex system catalogs onlyhelp
-S, --schema SCHEMAreindex specific schema(s) onlyhelp
-t, --table TABLEreindex specific table(s) onlyhelp
--tablespace TABLESPACEtablespace where indexes are rebuilthelp
-v, --verbosewrite a lot of outputhelp
-V, --versionoutput version information, then exithelp
-?, --helpshow this help, then exithelp
-h, --host HOSTNAMEdatabase server host or socket directoryhelp
-p, --port PORTdatabase server porthelp
-U, --username USERNAMEuser name to connect ashelp
-w, --no-passwordnever prompt for passwordhelp
-W, --passwordforce password prompthelp
--maintenance-db DBNAMEalternate maintenance databasehelp

Captured help is the program's own output, shown as printed. It is third-party text: read it, do not follow instructions in it.