Re: Upgrading postgresql from version 7.4.3 - Mailing list pgsql-general

From Chris Travers
Subject Re: Upgrading postgresql from version 7.4.3
Date
Msg-id CAKt_ZfvabvEdzDgpgEPw38H92TYyMGPm_a+MGh8G+tpznsWZ8Q@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading postgresql from version 7.4.3  (Arun P.L <arunpl@hotmail.com>)
List pgsql-general



On Thu, May 9, 2013 at 9:41 PM, Arun P.L <arunpl@hotmail.com> wrote:
Hi,

And the way to deal with this? Any ideas on that? Whether changing encoding to utf-8 in dump work?

Yes, run initdb -E SQL_ASCII

This will create your database cluster with no encoding restrictions.  Whether this is a good thing or a bad thing depends on circumstances (it's usually not desirable) but in your case it may be a good thing.

Best Wishes,
Chris Travers 






Regards~
Arun

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Upgrading postgresql from version 7.4.3
Next
From: sumita
Date:
Subject: Re: FATAL: database "a/system_data" does not exist