Problem with timezone in query console

My host server reports using PST/PDT as the timezone and I have a line in my postgresql.conf file setting:

timezone = ‘US/Pacific’

When I log in to my postgres server using psql and execute ‘show timezone’ it correctly returns ‘US/Pacific’. However, when I connect to a query console using DataGrip in PyCharm ‘show timezone’ returns UTC. I initially did not have any custom settings in my connection properties. I tried explicitly setting the timezone to ‘US/Pacific’ using the ‘Options’ tab, but ‘show timezone’ still returns UTC after reloading the connection.

0
2 comments

I tried explicitly setting the timezone to ‘US/Pacific’ using the ‘Options’ tab

Just tested on my machine - working as expected.

See if it helps to force refresh the connection (or simply deactivate and then reconnect).

0

Strangely, force refreshing did not work, but deactivating and then reconnecting did seem to work. Thanks.

0

Please sign in to leave a comment.