reindex man page on BSDOS

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDOS logo
[printable version]

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]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server BSDOS

List of man pages available for BSDOS

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]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net