Message-ID: <541C7CF3.2070204@gmail.com>
Date: Fri, 19 Sep 2014 14:58:59 -0400
From: John Scalia <jayknowsunix@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.6.0
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Missing locale files according to psql
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

I've been troubleshooting some connection problems with one of our servers recently, and as part of the effort, I ran psql through strace in order to see what was going on. Oddly 
enough, I saw a bunch of "problems". The output contained:

open("/usr/pgsql-9.3/share/locale/en_US.UTF-8/LC_MESSAGES/pgsql-9.3.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/pgsql-9.3/share/locale/en_US.utf8/LC_MESSAGES/pgsql-9.3.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/pgsql-9.3/share/locale/en_US/LC_MESSAGES/pgsql-9.3.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/pgsql-9.3/share/locale/en.UTF-8/LC_MESSAGES/pgsql-9.3.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/pgsql-9.3/share/locale/en.utf8/LC_MESSAGES/pgsql-9.3.mo", O_RDONLY) = -1 ENOENT (No such file or directory)
open("/usr/pgsql-9.3/share/locale/en/LC_MESSAGES/pgsql-9.3.mo", O_RDONLY) = -1 ENOENT (No such file or directory)

I looked in /usr/pgsql-9.3/share/locale and only saw "cs    de es       fr    it    ja    pl     pt_BR        ro    ru    sv tr    zh_CN    zh_TW"
but nothing looking like en* anything. Now, my connection problem is only with one server, and psql works to other 2 servers, but what should I have in the locale directory? After 
the above error block, it appears that psql gives up and just continues initializing. I don't see any more attempts to load an locale files. If it makes a difference, this is 
postgreSQL 9.3.3 on CentOS 6.5 loaded via yum installs.
--
Jay


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin