Re: pg_restore fails - postgres 7.3.4 - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_restore fails - postgres 7.3.4
Date
Msg-id 11219.1065125585@sss.pgh.pa.us
Whole thread Raw
In response to pg_restore fails - postgres 7.3.4  ("Rob Long" <rlong@micropat.com>)
List pgsql-admin
"Rob Long" <rlong@micropat.com> writes:
> Trying to dump and restore a production database with no success.

> pg_restore: [archiver (db)] could not execute query: ERROR: data type
> integer has no default operator class for access method "gist"

Hm, this is probably a matter of incorrect object restoration order ...
could we see the output of "pg_restore -l" for this dump file?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Rob Long"
Date:
Subject: pg_restore fails - postgres 7.3.4
Next
From: "Rob Long"
Date:
Subject: Re: pg_restore fails - postgres 7.3.4