An RSpec matcher to check a user is allowed to connect to a database using TCP/IP connections unconditionally.

postgresql_matchers.rb

module PostgresqlMatchers
  RSpec::Matchers.define :permit_user do |user|
    match do |content|
      !(content=~/host #{@database} #{user} 127\.0\.0\.1\/32 trust/).nil?
    end

    chain :to_connect_to do |database|
      @database = database
    end

    failure_message_for_should do |content|
      "expected user #{user} to be permitted to connect to database #{@database}"
    end
  end
end