parihaaraka <parihaaraka@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
