Postgresql 9.2.4 - timezone error

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

Responses

Browse pgsql-general by date

  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