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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin