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

Forgery · Accepted Answer · 2019-10-04 11:45:28Z

4

SET TIME ZONE 'UTC';

ALTER DATABASE your_db_name SET timezone TO 'UTC';

answered Oct 4, 2019 at 11:45

Forgery

1087 bronze badges

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

2 Comments

Are you proposing both of those options or just one?

both sql commands are doing the same thing and both of them change the timezone for the session only, not a permanent change

Laurenz Albe · Accepted Answer · 2019-10-04 12:54:20Z

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.

answered Oct 4, 2019 at 11:33

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Perhaps the server's clock is wrong? I added that option to the answer.