pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedMissing locale files according to psql
5+ messages / 4 participants
[nested] [flat]
* Missing locale files according to psql
@ 2014-09-19 18:58 John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: John Scalia @ 2014-09-19 18:58 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Missing locale files according to psql
@ 2014-09-22 18:06 Peter Eisentraut <peter_e@gmx.net>
parent: John Scalia <jayknowsunix@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2014-09-22 18:06 UTC (permalink / raw)
To: John Scalia <jayknowsunix@gmail.com>; pgsql-admin
On 9/19/14 2:58 PM, John Scalia wrote:
> 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)
This is not a problem. It's looking for message translation files for
en_US, but if they are not there, it will proceed without them.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Missing locale files according to psql
@ 2014-09-22 18:08 jayknowsunix@gmail.com
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 5+ messages in thread
From: jayknowsunix@gmail.com @ 2014-09-22 18:08 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
Ok, enough, but if they're not included in the PostgreSQL rpm, why does psql look for them?
Sent from my iPad
> On Sep 22, 2014, at 2:06 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
>
>> On 9/19/14 2:58 PM, John Scalia wrote:
>> 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)
>
> This is not a problem. It's looking for message translation files for
> en_US, but if they are not there, it will proceed without them.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Missing locale files according to psql
@ 2014-09-22 18:34 Peter Eisentraut <peter_e@gmx.net>
parent: jayknowsunix@gmail.com
0 siblings, 1 reply; 5+ messages in thread
From: Peter Eisentraut @ 2014-09-22 18:34 UTC (permalink / raw)
To: jayknowsunix@gmail.com; +Cc: pgsql-admin
On 9/22/14 2:08 PM, jayknowsunix@gmail.com wrote:
> Ok, enough, but if they're not included in the PostgreSQL rpm, why does psql look for them?
This is how locales work, independent of PostgreSQL or psql. You set a
locale in the environment, the operating system looks if locale
information files are installed, and if not in proceeds with a fallback.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Missing locale files according to psql
@ 2014-09-22 19:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Eisentraut <peter_e@gmx.net>
0 siblings, 0 replies; 5+ messages in thread
From: Tom Lane @ 2014-09-22 19:18 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin
Peter Eisentraut <peter_e@gmx.net> writes:
> On 9/22/14 2:08 PM, jayknowsunix@gmail.com wrote:
>> Ok, enough, but if they're not included in the PostgreSQL rpm, why does psql look for them?
> This is how locales work, independent of PostgreSQL or psql. You set a
> locale in the environment, the operating system looks if locale
> information files are installed, and if not in proceeds with a fallback.
Perhaps more to the point: there is a defined search path that libc is
supposed to follow when looking to see if there is a messages file for
the application. It does not know in advance whether the app has a
messages file or exactly where in the path it'll be located.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-09-22 19:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-09-19 18:58 Missing locale files according to psql John Scalia <jayknowsunix@gmail.com>
2014-09-22 18:06 ` Peter Eisentraut <peter_e@gmx.net>
2014-09-22 18:08 ` jayknowsunix@gmail.com
2014-09-22 18:34 ` Peter Eisentraut <peter_e@gmx.net>
2014-09-22 19:18 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox