Deploy Rails Application on Heroku : ERROR

Question

I am trying to execute heroku run rake db:migrate, but that's the result : rake aborted! PG::Error: ERROR: invalid value for parameter "client_encoding": "utf8mb4"

I want to use mysql database in development and postgres in production, and so that's the way that I configured my database.yml :

postgres: &postgres
  adapter: postgresql
  encoding: unicode
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
mysql: &mysql
  adapter: mysql2
  encoding: utf8mb4
  pool: <%= ENV.fetch("RAILS_MAX_THREADS") { 5 } %>
  username: root
  password:
  socket: /var/run/mysqld/mysqld.sock
development:
  <<: *mysql
  database: event_development
test:
  <<: *mysql
  database: event_test
production:
  <<: *postgres
  database: event_production
  username: event
  password: <%= ENV['EVENT_DATABASE_PASSWORD'] %>

How can I solve this?

7urkm3n · Accepted Answer · 2020-01-30 04:28:50Z

1

Just use url for it. If you have installed "Heroku Postgres" add-on. There supposed to be the DATABASE_URL in config vars.

database.yml:

...
production:
   url: <%= ENV['DATABASE_URL'] %>

answered Jan 30, 2020 at 4:28

7urkm3n

6,3304 gold badges33 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deploy Rails Application on Heroku : ERROR

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related