REINDEX  -  Recover  corrupted system indexes under stand-
       alone Postgres


SYNOPSIS

       REINDEX { TABLE | DATABASE | INDEX } name [ FORCE ]

   INPUTS
       TABLE  Recreate all indexes of a specified table.

       DATABASE
              Recreate  all  system  indexes   of   a   specified
              database.

       INDEX  Recreate a specified index.

       name   The name of the specific table/database/index to be
              be reindexed.

       FORCE  Recreate indexes  forcedly.  Without  this  keyword
              REINDEX  does  nothing  unless  target  indexes are
              invalidated.

   OUTPUTS
       REINDEX
              Message returned if the table is successfully rein­
              dexed.


DESCRIPTION

       REINDEX  is  used to recover corrupted system indexes.  In
       order to run REINDEX command, postmaster must be shut down
       and  stand-alone  Postgres  should be started instead with
       options -O and -P (an option to  ignore  system  indexes).
       Note  that  we  couldn't  rely  on  system indexes for the
       recovery of system indexes.


USAGE

       Recreate the table mytable:

            REINDEX TABLE mytable;

       Some more examples:

       REINDEX DATABASE my_database FORCE;
       REINDEX INDEX my_index;

   SQL92
       There is no REINDEX in SQL92.


Man(1) output converted with man2html