Bhushan Pathak <bhushan.pathak02@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. 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