"Feld, Michael (IMS)" <FeldM@xxxxxxxxxx> writes: > Thanks for the assist Tom. That worked for us. Noticing a different > issue following the pg_upgrade. If we take a pg_dump of a database on > this upgraded instance with the hstore extension and try to pg_restore > it back up to the same instance we get the following errors Those are the *only* errors you get? That seems rather odd. I could believe something like this happening if, say, you had an "unpackaged" (that is, pre-extensions) version of hstore lying about. But then you'd probably get conflicts on all the hstore-related objects, not only the opclasses. In any case, by far the most likely explanation is that you're trying to restore into a non-empty database, probably because you've put stuff into template1 and are cloning the new database from there. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
