update to use the new adapter_class methods from AR 7.1 (command-line client not found for dbconsole)

[copiousfreetime]

It looks like with rails 7.1 the method to find the dbconsole has been delegated to the adapter class,

• rails/rails#46093

With rails 7.1, and using the postgis adapter:

% bundle exec rails dbconsole -p
Unknown command-line client for caic_development.

After some initial investigation, it looks like the the postgis adapter needs to be update to add in

module ActiveRecord
  module ConnectionHandling
    def postgis_adapter_class
    #...
   end
  end
end

I'll attempt to get a PR for this soon, but if this is something simple that someone else could take care of quickly, I'll leave it here.

Some references:

• rails/rails@5bb357f
• https://github.com/rails/rails/blob/d0a0bed67eafdd879b41ee4f4c488e8d1a79e1af/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb#L23-L32

[keithdoggett]

Thanks for opening this and pointing out the solution/references @copiousfreetime. I'm pretty busy right now but should have time in the next few days to open a PR.