Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 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 -> /

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 JBO

Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Jerry Sievers
Bhushan Pathak 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 throwing out the error - >

Re: [GENERAL] Postgresql 9.2.4 - timezone error

2014-05-29 Thread Tom Lane
Bhushan Pathak 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. On any Red Hat-derived

[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: