How to change timezone of postgreSQL 9.5 on docker?

Question

Default timezone is UTC. But I want to change it to GMT+2. I tried as below.

alter database governance set timezone = 'GMT+2';

But it does't work.

How can I manage it?

postgresql version is 9.5. And it run on Docker.

Thanks!

score 38 · Answer 1 · answered Aug 05 '18 at 19:28

38

You should set timezone in your docker compose file (TZ and PGTZ are required):

postgres:
    image: postgres
    environment:
        TZ: 'GMT+2'
        PGTZ: 'GMT+2'

Reference: https://github.com/docker-library/postgres/issues/137#issuecomment-217064811

answered Aug 05 '18 at 19:28

mortymacs

3,456
3
27
53

why does it require two keys to set? – Dulara Malindu Feb 21 '21 at 12:28
@DularaMalindu `TZ` is for GNU/Linux and `PGTZ` is for PostgreSQL. – mortymacs Feb 21 '21 at 18:43
2

Thanks! Works great for `postgres:14.1` image too. – Binita Bharati Feb 10 '22 at 11:15
For anyone with an issue use timezones using: select * from pg_timezone_names; Reference: https://www.postgresql.org/docs/14/view-pg-timezone-names.html – Anutosh Chaudhuri Apr 26 '22 at 14:24
What if I want to change the timezone for a running container ? I don't want to recreate it – shellking4 Feb 18 '23 at 21:03
@shellking4 have you tried this query `SET TIME ZONE 'GMT+2';`? ref: https://stackoverflow.com/a/6663848/2338672 – mortymacs Feb 19 '23 at 10:34
@mortymacs thank you very much. It does change the timezone :)) – shellking4 Feb 19 '23 at 13:16

Denis Rudov · Answer 2 · 2021-07-09T12:36:00.240

14

For those who uses TZ and nothing happens

the reason for me was that for the first time when container starts it stores TZ variable in PG config in mapped volume. and after changing docker compose file to another TZ value it stays the same and looks like it doesn't work. you should remove db first and then restart docker-compose

edited Jul 09 '21 at 12:36

answered Jan 30 '21 at 16:28

Denis Rudov

833
8
16

1

Thanks for this, the logs were stuck on the wrong time zone for me – Chagai Friedlander Mar 29 '21 at 20:16

German · Answer 3 · 2017-06-07T13:18:55.163

11

To change timezone of you image try this:

docker run -it -e "TZ=GMT+2" postgres:alpine

docker-compose.yml

postgres:
  image: postgres:alpine
  environment: 
    - TZ=GMT+2

edited Jun 07 '17 at 13:18

answered Jun 06 '17 at 17:34

German

1,449
12
13

My explanation was insufficient. I'm using docker-compose.yml. And I tried to add environment: TZ: GMT+2 But it doesn't work. – Harry Jun 07 '17 at 08:38
Can you post the docker-compose.yml? – German Jun 07 '17 at 13:11

score 4 · Answer 4 · answered Nov 25 '17 at 23:43

4

You have to specify the timezone in the docker-compose.yml file in this format:

postgres:
    image: postgres:alpine
    environment:
        TZ: "Europe/Madrid"

answered Nov 25 '17 at 23:43

BhEaN

71
4

How to change timezone of postgreSQL 9.5 on docker?

4 Answers4

Linked