From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Upgrade: 9.0.5->9.4 |
Date: | 2014-03-21 16:49:57 |
Message-ID: | 532C6DB5.8050008@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/21/2014 09:34 AM, Rich Shepard wrote:
>
> Postgresql-9.0.5 is installed in /usr/local/pgsql/ and -9.4's data/
> subdirectory is installed in /var/lib/pgsql/9.4/ with the executable in
> /usr/bin/.
>
> Running pg_upgrade fails at the end because of a locale difference:
>
> lc_ctype cluster values do not match: old "C", new "en_US.UTF-8"
> Failure, exiting
>
> How do I remedy this?
If you want to use pg_upgrade, then you are going to have to dump your
old database, clean it to UTF-8 (with say iconv), then reimport it.
At that point you might as well just pull it into 9.3.
JD
>
> Thanks in advance,
>
> Rich
>
>
--
Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
Political Correctness is for cowards.
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2014-03-21 16:52:26 | Re: Upgrade: 9.0.5->9.4 |
Previous Message | Rich Shepard | 2014-03-21 16:49:47 | Re: Upgrade: 9.0.5->9.4 |