Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rudolf van der Leeden <rudolf(dot)vanderleeden(at)scoreloop(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, Rudolf van der Leeden <vanderleeden(at)logicunited(dot)com>
Subject: Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension
Date: 2011-11-21 16:27:46
Message-ID: 27172.1321892866@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I wrote:
> Rudolf van der Leeden <rudolf(dot)vanderleeden(at)scoreloop(dot)com> writes:
>> we are running into a problem with the following upgrade scenario:

> Hmm. I think the citext update script is missing a couple of things.

This patch seems to fix the case for me:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=94bdb198813b079467d7ed07c6f72ac896da7161

If you have an already-upgraded database, you can just run the
additional commands by hand.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jean-Armel Luce 2011-11-21 16:45:59 Re: rsync and streaming replication
Previous Message Tom Lane 2011-11-21 14:51:00 Re: Upgrading DBs with type=citext from 9.0.5 to 9.1.1 using pg_upgrade and create extension