Unix‎ > ‎Solaris‎ > ‎Solaris man pages‎ > ‎1‎ > ‎

reindexdb


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

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  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  documenta-
     tion)










Man pages from Solaris 10 Update 8. See docs.sun.com and www.oracle.com for further documentation and Solaris information.
Comments