First time here? Check out the FAQ!

How to reindex?

I'm getting some emails from my Askbot installation with following errors:

DatabaseError: index "django_session_pkey" contains unexpected zero page at block 13169
HINT:  Please REINDEX it.

How how to reindex correctly?

edit flag offensive 0 remove flag close merge delete

Comments

Sort by

This page should help you http://www.postgresql.org/docs/8.1/static/sql-reindex.html Stop the webserver and run the reindex command on the specific table or the whole database.

Just in case, make a db backup before doing that.

edit flag offensive 0 remove flag delete link