Re: Postgresql 9.2.4 - timezone error

Bhushan Pathak <bhushan(dot)pathak02(at)gmail(dot)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. On any Red Hat-derived system, /usr/share/zoneinfo/America/New_York
ought to be a plain file and none of the directories above it should
be symlinks either.

> What does this really mean?

It probably means there's a circular loop of symlinks at one of the steps
along that file path, for instance /usr/share/zoneinfo might be a symlink
pointing to itself. This would break many things not only Postgres.

You need to get rid of whatever's nonstandard there and reinstall the
regular tzdata package from Red Hat/CentOS.

regards, tom lane