FATAL: invalid value for parameter "TimeZone": "Australia/Canberra"

1.6k views Asked by At

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.

1

There are 1 answers

1
Nolwennig On

The recognized time zone names are listed in the pg_timezone_names view (see Section 45.67).

Australia/Canberra is in pg_timezone_names ?