Re: reindexing

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