All geek questions in one place

How to override pool and reaping_frequency in heroku database.yml

I am using a hero with Rails 4.1.1 and Ruby 2.1.1. I am using the default database configuration for heroku. This is why I put database.yml in .gitignore and I do not use database.yml to create.

I ran into a problem for "PG :: ConnectionBad: PQsocket () cannot get a socket descriptor", and to solve this problem I need to set reaping_frequency ("reaping_frequency" can tell Active Record to check if it hangs or is dead every N seconds and completes Although it is likely that over time your application may have several connections that hang, if something in your code causes freezes, the header will not be a permanent fix for the problem.).

Now I want to add this configuration to the .yml database.

reaping_frequency: 10

so do I have to directly add this configuration compared to database.yml for redefinition, or is there any other better way to set this frequency in the hero?

Thanks in advance for the suggestion.

+6
source share
2 answers

In config / unicorn.rb or config / puma.rb, set the pool and reaping_frequency in config:

 config = ActiveRecord::Base.configurations[Rails.env] || Rails.application.config.database_configuration[Rails.env] config['pool'] = ENV['DB_POOL'] || 5 config['reaping_frequency'] = ENV['DB_REAP_FREQ'] || 10 # seconds ActiveRecord::Base.establish_connection(config)
+5
source

Rails 4.0+ can directly specify pool and reaping_frequency in config/database.yml .

See Parameters in the following API links:

+3
source

Source: https://habr.com/ru/post/979323/

More articles:


All Articles