On Tue, Sep 25, 2012 at 09:10:33AM -0400, Bruce Momjian wrote:
> > lc_collate cluster values do not match: old "zh_CN.utf8", new "zh_CN.UTF-8"
> > Failure, exiting
> > 
> > zh_CN.utf8 is provided by the installer and zh_CN.UTF-8 is my system
> > default.
> 
> OK, this tells us that the canonicalization code used in initdb is not
> going to help us in pg_upgrade, at least not on your system, and not on
> mine.
> 
> I think we should apply the patch that fixes the TOAST problem with
> information_schema, and the patch that outputs the old/new values for
> easier debugging.  Other than that, I don't know what else we can do
> except to ignore dashes when comparing locale names, which I am told is
> unacceptable.

Based on this great bug report and submitter leg-work, I have applied
three patches to pg_upgrade in head and 9.2, all attached:

*  try to get the canonical locale names, and report old/new values on mismatch
*  update query to skip toast tables for system objects
*  improve error reporting when the object counts don't match

None of these bugs caused pg_upgrade to produce an incorrect upgraded
cluster, so I am not going to panic and try to force them into 9.1,
which probably isn't being used by many people anymore anyway.

I think this closes this report.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

In response to

• Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed at 2012-09-25 13:10:33 from Bruce Momjian

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2012-10-02 16:02:13
	Subject: xmalloc => pg_malloc
Previous:	From: Karl O. Pinc	Date: 2012-10-02 15:46:37
	Subject: Re: Doc patch to note which system catalogs have oids

pgsql-admin by date

Next:	From: Babay Adi, Hava	Date: 2012-10-02 18:54:09
	Subject: Creating schema best practices
Previous:	From: Albe Laurenz	Date: 2012-10-02 07:43:58
	Subject: Re: Debian Squeeze - no xml support for Pg 9.2