On Thu, Aug 22, 2013 at 11:29 AM, Don Parris <parrisdc(at)gmail(dot)com> wrote:
> On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop <stuart(at)stuartbishop(dot)net>wrote:
>> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris <parrisdc(at)gmail(dot)com> wrote:
> you install the PostgreSQL packages, it runs pg_createcluster for you.
>> If you don't like the locale or encoding you used, you run
>> pg_dropcluster and pg_createcluster as you did. The reason why your
>> database did not work after doing this is probably obvious from your
>> log files.
>> Hi Stuart,
> But I still come back to the locale issue. I am glad I was on the right
> track in replacing the cluster. Still, how could I have made UTF-8 the
> default encoding at install time? Maybe the very first step on a Kubuntu
> system should be to replace the cluster before doing anything else. Or
> maybe there is a locale setting that can be changed to ensure the pgsql
> package gets the 'right' cues?
I did find a (bit dated) response on the UbuntuForums site, but assume the
basic advice applies:
The recommendation is to change the OS locale settings and use dpkg to
reconfigure locales *before* recreating the cluster.
I really do think the Ubuntu documentation needs to clarify that.
Finally, I am ever more convinced that a recent update effectively blew up
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
GPG Key ID: F5E179BE
In response to
pgsql-general by date
|Next:||From: Robert James||Date: 2013-08-22 22:30:37|
|Subject: Column names for INSERT with query|
|Previous:||From: Vincent Veyron||Date: 2013-08-22 21:12:31|
|Subject: Re: Locale Issue|