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? -- *Melvin Davidson*