Re: [GENERAL] Locale Issue

2013-08-23 Thread Vincent Veyron
Le jeudi 22 août 2013 à 20:06 -0400, Don Parris a écrit : > locale showed everything *except* LC_ALL as being en_US.UTF-8. > LC_ALL was empty. I can only guess that the LC_ALL setting may have > played a part in the problem. I doubt it, mine was not set either and the installation went fine. Se

Re: [GENERAL] Locale Issue

2013-08-22 Thread Don Parris
On Thu, Aug 22, 2013 at 5:12 PM, Vincent Veyron wrote: > Le jeudi 22 août 2013 à 11:29 -0400, Don Parris a écrit : > > > Still, how could I have made UTF-8 the default encoding at install > > time? > > I did several recent installations of Postgresql on Debian Wheezy with > UTF8 and LATIN9, and

Re: [GENERAL] Locale Issue

2013-08-22 Thread Don Parris
On Thu, Aug 22, 2013 at 11:29 AM, Don Parris wrote: > On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote: > >> On Wed, Aug 21, 2013 at 4:55 PM, Don Parris wrote: >> >> > you install the PostgreSQL packages, it runs pg_createcluster for you. >> If you don't like the locale or encoding you use

Re: [GENERAL] Locale Issue

2013-08-22 Thread Vincent Veyron
Le jeudi 22 août 2013 à 11:29 -0400, Don Parris a écrit : > Still, how could I have made UTF-8 the default encoding at install > time? I did several recent installations of Postgresql on Debian Wheezy with UTF8 and LATIN9, and my system's encoding was used every time. Installation steps outl

Re: [GENERAL] Locale Issue

2013-08-22 Thread Don Parris
On Thu, Aug 22, 2013 at 3:23 AM, Stuart Bishop wrote: > On Wed, Aug 21, 2013 at 4:55 PM, Don Parris 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

Re: [GENERAL] Locale Issue

2013-08-22 Thread Stuart Bishop
On Wed, Aug 21, 2013 at 4:55 PM, Don Parris 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 tha

Re: [GENERAL] Locale Issue

2013-08-21 Thread Don Parris
On Wed, Aug 21, 2013 at 10:08 AM, Tom Lane wrote: > Don Parris writes: > > > initdb will absorb locale/encoding from its environment, unless told > otherwise through a --locale switch. So the usual expectation would be > that it'd work like you want. Perhaps the Ubuntu packager set LANG=C i

Re: [GENERAL] Locale Issue

2013-08-21 Thread Tom Lane
Don Parris writes: > When I install the Kubuntu (13.04) postgresql (9.1) packages, the default > template1 encoding turns out to be ASCII, which is not really what I want. > My OS locale command reveals everything to be en_US.UTF-8, except for > LC_ALL, which is left open. initdb will absorb loca