How do we update the time zone database?
For example,
david=> select now() at time zone 'Africa/Johannesburg';
timezone
----------------------------
2015-03-15 14:38:57.038857
(1 row)
Works
However, the following fails:
david=> select now() at time zone 'Africa/Juba';
ERROR 5038: Timezone "Africa/Juba" not recognized
david=>
Yet, "Africa/Juba" is listed as a valid time zone.
http://en.wikipedia.org/wiki/List_of_tz_database_time_zones