Re: Upgrade: 9.0.5->9.4

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.