On Friday 06 Dec 2002 10:34 am, Jean-Christian Imbeault wrote:
> 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.
You run a backend manually without anything else being able to connect. See
"man postgres" for details. You'll want to shut down PG, start the backend
with -O -P flags and the database name, reindex and Ctrl-D to finish. Then,
restart PG normally.
HTH
--
Richard Huxton