Error Logstash: unable to load plugin Postgresql.jar

[Kostis95 (Kostis)]

Hi there,

I'm trying to get started with elasticsearch and to use it for our forum data (which is stored in a postgresql database). I read that it would be possible to sync a postgresql database with elastic by using logstash. So in usr/local/etc/logstash I've got all files in place (logstash.yml, p1.conf, pipelines.yml). I've put the postgresql jar on my Desktop and refer to it in the p1.conf file like so:
jdbc_driver_library => "Users/{myUserName}/Desktop/postgresql-42.2.9.jar"
However when running logstash I get a pluginLoadingError that states that there is no such file to load. I can't see what I'm doing wrong here, so any help would be appreciated!

[Kostis95 (Kostis)]

I found the solution. You need to give all users Read & Write access (I'm using Mac OS). And instead of writing the path to our conf file like: "Users/user/Desktop/postgresql-42.2.9.jar" you write it like "~/Desktop/postgresql-42.2.9.jar".
After that all seems to be resolved.