Re: upgrade from 8.1.11 to 8.1.18 - Mailing list pgsql-admin

From Lewis Kapell
Subject Re: upgrade from 8.1.11 to 8.1.18
Date
Msg-id 4AD391B5.4050903@setonhome.org
Whole thread Raw
In response to upgrade from 8.1.11 to 8.1.18  (Marc Fromm <Marc.Fromm@wwu.edu>)
List pgsql-admin
Indexes are created as B-tree type unless you explicitly call for
another type when creating the index.  I get the impression that other
index types are not commonly used in most applications.

If you look at the index definition using, say, psql from the command
line, or a graphical tool like pgAdmin, look for the keyword 'btree'
after the index name but before the list of indexed columns.  If all
your indexes have that, then you don't have any GiST or hash indexes.

In psql, type:

\d mytablename

to see the table definition, this will show the indexes on that table also.

If your database has a lot of tables/indexes such that it would take you
too long to inspect each one, then I don't know what you could do.
Maybe some of the more experienced folks on the list could suggest
something.

Lewis Kapell
Computer Operations
Seton Home Study School


Marc Fromm wrote:
> 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
>
>
>


pgsql-admin by date:

Previous
From: Marc Fromm
Date:
Subject: upgrade from 8.1.11 to 8.1.18
Next
From: "David F. Skoll"
Date:
Subject: Warm standby questions