Horton

Re: pg_upgrade from 9.0.7 to 9.1.3: duplicate key pg_authid_oid_index

Jeff Davis <pgsql@j-davis.com>

View thread
From: Jeff Davis <pgsql@j-davis.com>
To: Bryan Murphy <bmurphy1976@gmail.com>
Cc: PGSQL Mailing List <pgsql-general@postgresql.org>
Date: 2012-05-31T21:28:54Z
Lists: pgsql-hackers 
On Thu, 2012-05-31 at 15:55 -0500, Bryan Murphy wrote:
> I'm having a problem upgrading a cluster from 9.0.7 to 9.1.3.  Here's
> the error:

Please send /srv/pg_upgrade_dump_globals.sql

Also, can you restart the old system (by removing the ".old" suffix, as
the message suggests), and then do a "SELECT oid,* FROM pg_authid" and
send the output along?

Regards,
	Jeff Davis