Set timezone

[daniel-shuy]

Before closing this issue as a duplicate, all the other answers do not work.

You can try this by simply running:

docker run -e "TZ=UTC" -e "PGTZ=UTC" -p 5432:5432 postgres:12-alpine

then:

show timezone;

will still return local timezone instead of the timezone set in TZ/PGTZ. I've tried this with other timezones as well (eg. Europe/Amsterdam), as well as with older images (eg. 9.5-alpine).

[wglambert]

I can't reproduce

$ docker run -d --name postgres -e "TZ=UTC" -e "PGTZ=UTC" -e POSTGRES_PASSWORD=pass -p 5432:5432 postgres:12-alpine
2d54a60a00609495ca689bf29fc31f24cccd61fa51024e86226c764b22ab1f19

$ docker exec -it postgres ash

/ # date
Wed May 13 14:45:09 UTC 2020

/ # psql -Upostgres
psql (12.2)
Type "help" for help.

postgres=# show timezone;
 TimeZone 
----------
 UTC
(1 row)

[daniel-shuy]

Sorry, turns out DBeaver was setting the timezone in the session to localtime, I tried it using docker exec and it is UTC, thanks.

[wglambert]

I'm not able to reproduce

$ docker build -t postgres:test - << EOF
FROM postgres:alpine
ENV PGTZ=America/Los_Angeles
EOF
Sending build context to Docker daemon  2.048kB
Step 1/2 : FROM postgres:alpine
 ---> ebf01b748a56
Step 2/2 : ENV PGTZ=America/Los_Angeles
 ---> Running in ae49fc693778
Removing intermediate container ae49fc693778
 ---> d7eb5e9d5018
Successfully built d7eb5e9d5018
Successfully tagged postgres:test

$ docker run -d --name postgres -e POSTGRES_PASSWORD=test postgres:test
68c6e3226879d3627e06801cd959c2b1622c752727f1a9e39a4787d6930400d9

$ docker exec -it postgres psql -U postgres
psql (14.2)
Type "help" for help.

postgres=# show timezone;
      TimeZone
---------------------
 America/Los_Angeles
(1 row)

Also for some timezones PGTZ wants a location, if it gets an invalid variable it critical errors on start

$ docker build -t postgres:test - << EOF
FROM postgres:alpine
ENV PGTZ=PST
EOF
Sending build context to Docker daemon  2.048kB
Step 1/2 : FROM postgres:alpine
 ---> ebf01b748a56
Step 2/2 : ENV PGTZ=PST
 ---> Running in 2d382352675f
Removing intermediate container 2d382352675f
 ---> de6ad49d2511
Successfully built de6ad49d2511
Successfully tagged postgres:test

$ docker run -d --name postgres -e POSTGRES_PASSWORD=test postgres:test
f07d491721259179b2d9997e39d40645aa2daf0af6f6e2e3b85cfc70d078ecd0

$ docker logs postgres 2>&1 | tail -n 3
server started
2022-04-07 15:49:24.166 UTC [47] FATAL:  invalid value for parameter "TimeZone": "PST"
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: FATAL:  invalid value for parameter "TimeZone": "PST"

[a1723]

Sorry, turns out DBeaver was setting the timezone in the session to localtime, I tried it using docker exec and it is UTC, thanks.

u changed default timezone to UTC in preferences, yes ?