pg_timezone_names view is empty - can be recreated? For some strange reason pg_timezone_names view is empty. Is there a way to recreate it?
The pg_timezone_names view is populated when the server starts - it recursively reads the timezone files from &lt;your Postgres dir&gt;/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 &lt;your Postgres dir&gt;/share/timezone.

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