How to set the default timezone in PostgreSQL on Amazon RDS?

Question

The default timezone is currently set to UTC. How to replace that default value? I am using PostgreSQL running on top of Amazon RDS

Erik Reasonable Rates Darling · Accepted Answer · 2018-03-30 22:21:29Z

4

ALTER DATABASE <db_name> SET TimeZone = 'UTC'; But you shouldn't do that. Using UTC for database is safest thing possible.

44.1k14 gold badges140 silver badges514 bronze badges

answered Mar 30, 2018 at 21:22

Bogdan Mart

1906 bronze badges

it is the only solution if all the users are on the same single timezone
– Abel Melquiades Callejo
Commented May 17, 2018 at 5:15

Add a comment |

1 Answer 1