Postgres Pro
Downloads
Home   >   mailing lists

reindexing - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject reindexing
Date
Msg-id 3DF07D24.6060305@mega-bucks.co.jp
Whole thread Raw
Responses Re: reindexing  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
The online docs have this to say about reindexing a whole DB:

   Rebuild all system indexes (this will only work in a standalone
   backend):

   REINDEX DATABASE my_database FORCE;

What does "standalone backend" mean? And how can I use this command to
reindex my DB? I have tried version commands but always get:

ERROR:  REINDEX DATABASE: Can be executed only on the currently open
database.

Thanks!

Jc

pgsql-general by date:

Previous
From: "Robert Jenkins"
Date:
Subject: RPMs - minor problem
Next
From: Richard Huxton
Date:
Subject: Re: reindexing