Index for Section 1

Alphabetical listing for R

Bottom of page

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 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 connections.

  -U username

  --username username
       User name to connect as.

  -W

  --password
       Force password prompt.

ENVIRONMENT
  PGDATABASE

  PGHOST

  PGPORT

  PGUSER
       Default connection parameters

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 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 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)], Environment Variables (the documentation)

Index for Section 1

Alphabetical listing for R

Top of page