reindex man page on BSDi

reindex man page on BSDi

Man page or keyword search:
man Server 6284 pages
apropos Keyword Search (all sections)
Output format

REINDEX()			 SQL Commands			     REINDEX()

NAME
       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 rein‐
	      dexed.

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

   OUTPUTS
       REINDEX
	      Message returned if the table is successfully reindexed.

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;

COMPATIBILITY
   SQL92
       There is no REINDEX in SQL92.

SQL - Language Statements	 29 March 2001			     REINDEX()

[top]

List of man pages available for BSDi

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]

Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................

Vote for polarhome