pg_upgrade problem

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrade problem
Date: 2015-06-16 15:02:42
Message-ID: CANu8FixAkd+F4wbTPQPiTDpahG7ci28O1JLbgwn_S6mNHKyR_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2015-06-16 15:58:27 Re: pg_upgrade problem
Previous Message Xavier 12 2015-06-16 13:55:42 Re: pg_xlog on a hot_stanby slave