How can we change the Postgresql database server timezone from UTC? For example in postgresql.conf, we would like to use:
TimeZone = ‘America/Los_Angeles’
Note that we already set the machine timezone to America/Los_Angeles, but the database server continues to use UTC.
You could do the with sed. In your circle.yml change the postgresql.conf file and restart postgresql:
test:
pre:
- sudo sed -i 's/UTC/America\/Los_Angeles/' /etc/postgresql/9.4/main/postgresql.conf
- sudo service postgresql restart
Please see this build for a full working example where the test command echo’s the current time zone from PostgreSQL.