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