Re: Locale Issue

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:
>
> > I did run pg_dropcluster, pg_createcluster (setting locale to C.UTF8) -
> and
> > that seemed to work, except that I could not thereafter make remote
> > connections (despite resetting the hba and postgres.conf files as they
> > should be).
>
> Rather than chasing locales, I'd look into why you failed here. When
> 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,

Hi Stuart,

Your point is valid and well-taken. I discovered a couple of other issues
in my poking around:

<> The pgsql logs turned up empty (literally), so would have to rely on
system logs for any hints of connection issues.

<> It seems my iptables was ruined - I kept getting errors about needing an
update and the software update manager kept giving me errors on kernel
updates. I could not create iptables rules to open the port.

<> I also had problems with my SSH service.

I really suspect the whole connectivity issue was related to updates and
something going South with my iptables setup (among other possible issues).
I had been able to connect remotely before I replaced the cluster, but not
after, so I just cannot be too sure what ultimately caused the problem.

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?

An OpenSUSE 12.3 installation with pgsql 9.2 comes up with a UTF8-encoded
template1. So why does the (K)Ubuntu package default to an ASCII-encoded
template1? When I read the fine manual (and it really is pretty good), I
get the impression it is best to let initdb/pg_createcluster take its cue
from the OS locale settings. If my locale on Kubuntu shows up as UTF-8,
then why the seeming miscue? I am certain there is a reasonable
explanation, but that eludes me at this point.

Regards,
Don

--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/
<https://www.xing.com/profile/Don_Parris><http://www.linkedin.com/in/dcparris>
GPG Key ID: F5E179BE