Postgres error "invalid value for parameter "TimeZone": "UTC""
Solution 1:
I had the same problem using the Postgres.app from Heroku. Rebooting my Mac solved it.
Solution 2:
Restarting postgresql works.
To restart if you've installed it using homebrew, brew info postgresql
will tell you to:
launchctl unload ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
launchctl load ~/Library/LaunchAgents/homebrew.mxcl.postgresql.plist
Solution 3:
brew services restart postgresql
Solution 4:
Try restarting the server. I updated Postgresql through Homebrew but forgot to restart the server and got this same problem. I believe it's due to the client and server versions not matching. psql started with:
$ psql
psql (9.1.4, server 9.1.2)
Type "help" for help.