How do you enable database logging in production mode? (Rails v2.3.8)

Question

I have some oddities on my production server only and I need to be able to see all the database queries as in development mode.

I am sure it is a small config tweak, but I can't find any solutions.

Answer 1

In Rails 2.x, in the environment.rb file you have:

  # Force all environments to use the same logger level
  # (by default production uses :info, the others :debug)
  # config.log_level = :debug

In Rails 3.x should be something similar.