Ulrich Wisser <[EMAIL PROTECTED]> writes:
> -bash-2.05b$ postgres -D /var/lib/pgsql/data/ -O -P CLIX1
> ...
> backend> REINDEX DATABASE CLIX1
> ERROR: REINDEX DATABASE: Can be executed only on the currently open
> database.
The database name is evidently all upper case, so you need double
quotes
Hello,
the maintainance chapter in the docs gave me the impression that a
reindex of some tables would be a good idea. Last night I took the
database down, started up in single user mode and tried to reindex.
The reindex of tables did work fine, but a reindex of the database
did not. Please see