Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-30 Thread Bhushan Pathak
There was a redirect loop created somehow - [root ~]# ls -l /etc/localtime lrwxrwxrwx 1 root root 36 May 12 01:13 /etc/localtime - /usr/share/zoneinfo/America/New_York [root ~]# ll /usr/share/zoneinfo/America/New_York lrwxrwxrwx 1 root root 14 Feb 21 00:08 /usr/share/zoneinfo/America/New_York -

[GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Bhushan Pathak
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:

Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Tom Lane
Bhushan Pathak bhushan.patha...@gmail.com writes: 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 Oh? There's something really broken about your tzdata installation, then.

Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Jerry Sievers
Bhushan Pathak bhushan.patha...@gmail.com writes: 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

Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread rob stone
On Thu, 2014-05-29 at 20:22 +0530, Bhushan Pathak wrote: 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