pg_upgrade (9.1 to 9.2) bombing on casts

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_upgrade (9.1 to 9.2) bombing on casts
Date: 2013-07-12 04:55:14
Message-ID: CAOC+FBUPXxkwe+Qyx3e9_02h061L8OHgY4OUUtEFwwvYydbrig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have this error in a pg_upgrade:

psql:pg_upgrade_dump_db.sql:88725: ERROR: UNION could not convert type
text[] to integer[]

Command executed:

time \
/usr/lib/postgresql/9.2/bin/pg_upgrade -k \
-b /usr/lib/postgresql/9.1/bin \
-B /usr/lib/postgresql/9.2/bin \
-d /data/postgresql/9.1/test \
-D /data/postgresql/9.2/main \
-o '-D /etc/postgresql/9.1/test' \
-O '-D /etc/postgresql/9.2/main'

In a view using that sort of cast. I thought maybe pg_upgrade would be able
to handle any custom casts.. Is there some way of fixing this without
removing the offending view?

--
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2013-07-12 05:09:39 Re: pg_upgrade (9.1 to 9.2) bombing on casts
Previous Message Wells Oliver 2013-07-12 02:07:41 Couldn't start postgres, got no logging, ran postgres manually for info-- help?