"Rob Long" <rlong(at)micropat(dot)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