invalid value for parameter "TimeZone": "US/Pacific-new"

Question

Jira 7 fails to connect to Postgresql 10

throws tihs:

org.postgresql.util.PSQLException: FATAL: invalid value for parameter "TimeZone": "US/Pacific-New"

I know the latest postgres is not in the list of supported databases

is there a workaround ?

Shannon S · Answer

Hi Yuriy,

I'm happy to hear the suggested change to go to a supported timezone fixed the issue! I wasn't personally aware of the issue with old versions of Linux and Postgres. This is something that we will surely be able to document once Postgres 10 is officially supported.

If you do run into any other issues using Postgres 10, please feel free to submit them as feedback and we can include a fix for it when a version of Jira is released that supports it.

Take care, and have a pleasant rest of your week!

Regards,

Shannon

Yuriy Grinberg_tdr8xm · Answer

It is sad when support team puts up a "not officially supported" barricade while the answer is rather simple.

older linux/jvm supplies the timezone that new postgres no longer recognizes

"-Duser.timezone America/Los_Angeles" is all it takes, thank god for google

It would have been so nice if you gave an actual answer.

It would be quite surprising if postgres actually dropped a fundamental SQL feature in v10 to make it unusable for jira.

all in all a rather unsatisfactory experience

i've been using jira for close to 15 years now, brought it to several companies

and now this...

Shannon S · Answer

Hi Yuriy,

To be clear, there is a good chance this won't solve your issue, since Postgres 10 isn't supported by Jira at this time.

Have a look at my colleague's response below:

* Postgres Time Zone for Jira and Confluence Databases

You will want to get in touch with your database admin if you have any issues getting that updated.

If you continue to encounter problems I highly recommend you migrate to a supported database version. There are no guarantees when running Jira off an unsupported database.

Shannon