What needs to be done depends on the kind of error you're running into. If the above error is the only problem it is easy to fix, you just need to rebuild the index as stated in the hint. As root, do the following:
# psql -U reporting -c "REINDEX DATABASE reporting"
