Clojure: java.jdbc can't connect to Postgres after changing OS timezone to UTC

Question

When I set my timezone on my server to UTC via timedatectl set-timezone UTC and restart Postgres server, I can connect via psql and verify that select now() returns the correct value.

When I try to start my Clojure app and run a query, I get the following error:

Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: org.postgresql.util.PSQLException: FATAL: invalid value for parameter "TimeZone": "UTC"

I am using the following database libraries in my app:

[org.postgresql/postgresql "9.4.1208"]
[clojure.jdbc/clojure.jdbc-c3p0 "0.3.2"]
[org.clojure/java.jdbc "0.6.1"]

The error looks like it comes from Postgres, but only happens when connecting via the Clojure app.

Everything works if I return the OS timezone to America/New_York

Community · Accepted Answer · 2017-05-23 11:51:46Z

2

Take a look at

postgres default timezone

See what timezone names are understood by the database:

SELECT * FROM pg_timezone_names;

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Sep 22, 2016 at 4:04

Jonah Benton

3,7081 gold badge18 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeremy Raines Over a year ago

This helped me to nail it down -- in my Postgres install, it understands "GMT" and "UCT" but not "UTC"

Collectives™ on Stack Overflow

Clojure: java.jdbc can't connect to Postgres after changing OS timezone to UTC

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related