On Thu, Aug 22, 2013 at 5:12 PM, Vincent Veyron <vv.li...@wanadoo.fr> 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 my system's encoding was used every time. > > Installation steps outlined below. > > Before you install Postgresql, make sure your systems encoding is set to > UTF-8, which you can check with : > locale -a > > If it's not, run : > dpkg-reconfigure locales > > and select UTF-8 for your language. > > Use apt-get to install Postgresql : > apt-get install postgresql postgresql-client > > I'm not sure if Kubuntu adds some overhead to the installation process. > You might want to try a regular debian install and add the KDE desktop > to it. > > Thanks Vincent. 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. See my previous e-mail (sent just a few minutes before this one). I may have also been fine if that system had not lost connectivity. Trying out things on OpenSUSE 12.3, I do have SSH connectivity and the Postgres server came up with template1 encoded as UTF-8 by default. I'll test out the pgsql remote connectivity soon as well.