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
