This message was deleted.
# troubleshooting
s
This message was deleted.
k
Hi swetha - have you added `postgresql-metadata-storage`to your
druid.extensions.loadList
? This should take care of loading the
jar
in the right place (
./extensions/postgresql-metadata-storage/postgresql-42.4.1.jar
)
s
yes I did add the extension
it is still not adding it though sadly
it adds in extension but the jar has to be available in lib folder too to get the work done
extension helps only to make postgresql as storage place for druid
k
My understanding is that this extension also adds the PostgreSQL firehose capability https://druid.apache.org/docs/latest/development/extensions-core/postgresql.html#postgresql-firehose so it should be included in the
common.runtime.properties
so it is loaded on all services
s
Nope may be in theoritical it makes sense but in practical it is not working though .
g
firehoses are deprecated and going to be removed in 26.0; maybe you'll have more luck with the input source? https://druid.apache.org/docs/latest/ingestion/native-batch-input-sources.html#sql-input-source
if that doesn't work for you, you could always do a dump of data from postgresql to CSV and load the CSV into Druid
s
i faced with same error p.s. i tried to add jdbc postgresql to lib folder p.s.2. i tried to use inputSource instead of firehose p.s.3. only updaloding of csv file from postgres and loading it into druid works