I was facing some troubles the other day in a PostsgreSQL RDS created in N.Virginia AWS, the RDS' timezone had to be synchronized in Colombia and as there are not any postgresql.conf in an AWS RDS in order to make that change you must connect to the database through the console, in my case I did something like this username = postgres database = postgres endpoint = test.chwc4bq271vn.us-east-1.rds.amazonaws.com psql -U postgres -h test.chwc4bq271vn.us-east-1.rds.amazonaws.com -p 5525 -d postgres ( replace all these by your credentials and your endpoint ) after you set the password and you get to the prompt run this alter database postgres set timezone TO 'America/Bogota'; change the time zone by the one you need, or run this command to list the available zones: select * from pg_timezone_names ; after you have done the process, test it creating a table which you give it an id and it sets automatically the date ...