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


     reindexdb - reindex a PostgreSQL database

     reindexdb [ connection-option... ]  [ --table | -t table   ]
     [ --index | -i index  ]  [ dbname ]

     reindexdb [ connection-option... ]  [ --all | -a ]

     reindexdb [ connection-option... ]  [ --system  |  -s  ]   [
     dbname ]

     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.

     reindexdb accepts the following command-line arguments:


          Reindex all databases.


          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.


          Echo the commands that reindexdb generates and sends to
          the server.


          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-

     -U username

     --username username
          User name to connect as.


          Force password prompt.




          Default connection parameters


     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.

     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.

     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

     REINDEX [reindex(5)], Environment Variables (the  documenta-

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