I've been troubleshooting some connection problems with one of our servers recently, and as part of the effort, I ran
psqlthrough 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
loadan locale files. If it makes a difference, this is
postgreSQL 9.3.3 on CentOS 6.5 loaded via yum installs.
--
Jay