Postgres error “invalid value for parameter ”TimeZ

Question

Jupitor$ bundle exec rake db:create db:migrate
APP_development already exists
rake aborted!
PG::Error: ERROR:  invalid value for parameter "TimeZone": "UTC"
: SET time zone 'UTC'

I keep getting this error when trying to migrate to my postgres database. help would be much appreciated!

Answer 1

just restarting the database helped. Homebrew updated my Postgres installation and I did not restart yet.

Answer 2

I also had this problem.

Login to the database then issue:

set time zone utc;

Answer 3

I had the same problem using the Postgres.app from Heroku. Rebooting my Mac solved it.