Janning Vygen <[EMAIL PROTECTED]> writes:
> At
> http://www.postgresql.org/docs/8.0/static/sql-reindex.html
> it says:
> Rebuild all system indexes in a particular database,
> without trusting them to be valid already:
> $ export PGOPTIONS="-P"
> $ psql broken_db
> It should be:
> Rebuild all system indexes in a particular database,
> without trusting them to be valid already:
> $ export PGOPTIONS="-P"
> $ postgres broken_db
> ^^^^^^^^
> ,shouldn't it?
No, it's correct as it stands. You used to need a standalone backend
for that, but not anymore. (PGOPTIONS isn't recognized by a standalone
backend anyway, IIRC, so there would be more wrong with the example than
that if it were wrong.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
