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