Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For some strange reason pg_timezone_names view is empty. Is there a way to recreate it?

share|improve this question
select pg_timezone_names(); returns 0 rows – Alex Aug 8 '13 at 9:30
up vote 4 down vote accepted

The pg_timezone_names view is populated when the server starts - it recursively reads the timezone files from <your Postgres dir>/share/timezone and they are used to provide data for the view.

Double check that the files exist (as they should in a full installation) and that the user you are running the database under has read permission on all of the directories and files under <your Postgres dir>/share/timezone.

You'll need to restart the RDBMS for changes to take effect.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.