upgrade from 8.1.11 to 8.1.18

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: upgrade from 8.1.11 to 8.1.18
Date: 2009-10-12 20:15:56
Message-ID: B0D7C0A3F35FE144A70312D086CBCA9B03A9A2D3DE@ExchMailbox2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lewis Kapell 2009-10-12 20:29:41 Re: upgrade from 8.1.11 to 8.1.18
Previous Message Shane Ambler 2009-10-12 17:21:19 Re: How to size a log file partition