First time here? Check out the FAQ!
0

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?

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Toms's avatar
767
Toms
asked 11 years ago

Comments

see more comments

1 Answer

0

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.

To enter a block of code:

  • enter empty line after your previous text
  • paste or type the code
  • select the code and press the button above
Preview: (hide)
Evgeny's avatar
13.2k
Evgeny
answered 11 years ago
link

Comments

see more comments