How to change AWS RDS Postgres database timezone?

Question

I am trying to change the RDS timezone to UTC,
I'm using an SQL Client called DBeaver

I tried the following two commands -

1. Configuration Parameter Name -

SET timezone TO 'UTC';

and

2. Standard SQL Command -

SET TIME ZONE 'UTC';

But the select now(); command still doesn't return the UTC time

I am referring this answer -
postgres default timezone

Tried the following -

echo $PGTZ

score 4 · Answer 1 · answered Oct 04 '19 at 11:45

4

SET TIME ZONE 'UTC';

ALTER DATABASE your_db_name SET timezone TO 'UTC';

answered Oct 04 '19 at 11:45

Forgery

1

Are you proposing both of those options or just one? – entpnerd Oct 04 '19 at 21:17
both sql commands are doing the same thing and both of them change the timezone for the session only, not a permanent change – Julian Eccleshall May 03 '21 at 06:07

Laurenz Albe · Answer 2 · 2019-10-04T12:54:20.500

2

Maybe you are using a connection pool, and session settings get cleared when the session returns to the pool.

You could try something like

ALTER ROLE your_user SET timezone = 'UTC';

You must reconnect for this to take effect.

Also, check if the environment variable PGTZ is set in your environment. It will override the database settings.

If all that doesn't do the trick, consider the possibility that the server's time is off.

edited Oct 04 '19 at 12:54

answered Oct 04 '19 at 11:33

Laurenz Albe

Perhaps the server's clock is wrong? I added that option to the answer. – Laurenz Albe Oct 04 '19 at 12:54

2 Answers2