Check rails postgres version

.postgres-version

10.6

check_postgres_version.rb

def check_postgres_version
  postgres_expected_version = `cat .postgres-version`.strip
  postgres_version = ActiveRecord::Base.connection.select_value("SELECT VERSION()").match(/[0-9]{1,2}([,.][0-9]{1,2})?/)[0]

  unless postgres_version.index(postgres_expected_version)
    abort("\e[31mInvalid PostgreSQL version. Please use '#{postgres_expected_version}', found '#{postgres_version}'\e[0m")
  end
end

check_postgres_version