I have tried to upgrade my 9.3.5 Postgresql to 9.3.7, I have used the source to make build from source and then I have pointed to the right version to start. I am using this D.B for Confluence 5.6.6 and I keep getting this
FATAL: invalid value for parameter "TimeZone": "Australia/Canberra"
I have noticed that shared library in 9.3.5 differs from 9.3.7, there is no timezone directory in the old version but both version contain timezonesets which are same.
The recognized time zone names are listed in the
pg_timezone_names
view (see Section 45.67).Australia/Canberra is in
pg_timezone_names
?