From: | Bhushan Pathak <bhushan(dot)pathak02(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Postgresql 9.2.4 - timezone error |
Date: | 2014-05-29 14:52:43 |
Message-ID: | CAHJHQJ5sOVk0385e9-gf4ncGD9CCxTZxCzHDYY_LC_JqOORvag@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I have postgresql 9.2.4 running on a CentOS 5 server. A JBOSS AS instance
also runs on the same server, which connects to postgresql server [using
defined connection pools].
The issue I'm facing is that the JBOSS server is throwing out the error -
org.postgresql.util.PSQLException: FATAL: invalid value for parameter
"TimeZone": "America/New_York"
When I looked up on the internet, most common answer was to execute the
following query from CLI which would expose the real problem -
myDB=# SELECT * FROM pg_timezone_names WHERE name = 'America/New_York';
ERROR: could not stat "/usr/share/zoneinfo/America/New_York": Too many
levels of symbolic links
What does this really mean? Why is postgresql complaining for symbolic
links? Any ideas what has gone wrong? Any thing that needs checking?
Thanks
Bhushan Pathak
From | Date | Subject | |
---|---|---|---|
Next Message | Kalai R | 2014-05-29 15:01:26 | Re: Postgresql service stopped automatically after restart |
Previous Message | Adrian Klaver | 2014-05-29 14:45:45 | Re: Postgresql service stopped automatically after restart |