pg_upgrade problem

Using pg_upgrade in 9.4 CentOS release 6.6 (Final) (from PostgreSQL 9.1.15) it fails when GRANTING permits to roles.


Checking pg_upgrade_dump_globals.sql, I see the point of failure is caused by the -- Role memberships section.

In there I see the following troublesome lines.
-- Role memberships
...
...
....
GRANT "supers" TO "pgpoolad" GRANTED BY "postgres";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "";
GRANT "" TO "" GRANTED BY "postgres";
GRANT "" TO "";
GRANT "" TO "";

Doing a pg_dumpall -g on the database produces the same result.

I am pretty sure this is catalog corruption.

Can anyone else confirm and/or suggest a recommended fix?


--