Re: pg_upgrade error regarding hstore operator - Mailing list pgsql-general

parihaaraka <parihaaraka@gmail.com> writes:
> I have the same issue after pg_upgrade from 9.3 to 9.5.
> pg_dump generates excess commands like
>   CREATE OPERATOR FAMILY bit_ops USING gin;
>   ...
> while all of this is done during CREATE EXTENSION

This is fixed in the latest round of minor releases, but not in a way that
will help you if you already pg_upgrade'd such an extension:

http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=6cead413b

Per the comments there, you could manually add that operator family back
to its extension, or just ignore the duplicate-opfamily complaints you'd
get during a restore.

            regards, tom lane