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? kind regards, janning ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings