Lookups with Postgres, how?


trying to setup lookups sourcing from postgres, but I fail to load the drivers.

Jan 21 13:17:41 ax51-nvme-dc11-48 druid-indexer[29308]: org.skife.jdbi.v2.exceptions.UnableToObtainConnectionException: java.sql.SQLException: No suitable driver found for jdbc:postgresql://postgres.url

How do I get the right class loader to do the Class.forName?



Can you confirm from your server startup logs that postgres extension is loaded correctly?

I am using Postgres in my druid setup, so it’s working and loaded.

I am assuming it’s some weird class loader issue, but (as always) it’s not obvious to debug it. Hence the question if anybody actually tried this before :slight_smile: