I need to upgrade postgresql from 8.1.11 to 8.1.18.
The documentation states to
REINDEX all GiST indexes and REINDEX hash indexes on interval columns after the upgrade.
I googled the two items only to find the same comment with no instructions on what they are or how to do it.
How can I check if I have any GiST indexes and hash indesxes on interval columns?
Is there a command to reindex all databases at once or must I do each individually?
Thanks
Marc