Hi all, I'm having trouble because I can't seem to get PIO to work with PostgreSQL. I've seen the following report:
*https://issues.apache.org/jira/browse/PIO-49 <https://issues.apache.org/jira/browse/PIO-49>PIO-49: PostgreSQL JDBC driver is no longer bundled with the core assembly. If you are using PostgreSQL, you must download the JDBC driver and update your configuration to point to the correct JDBC driver file.* However, it doesn't say how to update the configuration. How is this done? When I do 'pio status' I get the following message: *SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/home/VICOMTECH/noses/PredictionIO/apache-predictionio-0.11.0-incubating/PredictionIO-0.11.0-incubating/lib/spark/pio-data-hdfs-assembly-0.11.0-incubating.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: Found binding in [jar:file:/home/VICOMTECH/noses/PredictionIO/apache-predictionio-0.11.0-incubating/PredictionIO-0.11.0-incubating/lib/pio-assembly-0.11.0-incubating.jar!/org/slf4j/impl/StaticLoggerBinder.class]SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings <http://www.slf4j.org/codes.html#multiple_bindings> for an explanation.SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory][INFO] [Management$] Inspecting PredictionIO...[INFO] [Management$] PredictionIO 0.11.0-incubating is installed at /home/VICOMTECH/noses/PredictionIO/apache-predictionio-0.11.0-incubating/PredictionIO-0.11.0-incubating[INFO] [Management$] Inspecting Apache Spark...[INFO] [Management$] Apache Spark is installed at /home/VICOMTECH/noses/spark-2.2.0-bin-hadoop2.7[INFO] [Management$] Apache Spark 2.2.0 detected (meets minimum requirement of 1.3.0)[INFO] [Management$] Inspecting storage backend connections...[INFO] [Storage$] Verifying Meta Data Backend (Source: PGSQL)...[ERROR] [Management$] Unable to connect to all storage backends successfully.The following shows the error message from the storage backend.No suitable driver found for jdbc:postgresql://localhost/pio (java.sql.SQLException)Dumping configuration of initialized storage backend sources.Please make sure they are correct.Source Name: PGSQL; Type: jdbc; Configuration: URL -> jdbc:postgresql://localhost/pio, PASSWORD -> pio, TYPE -> jdbc, USERNAME -> pio* Any help pointing towards the correct configuration of the JDBC driver for PostgreSQL to work with PIO will be much appreciated! (I have alreade downloaded postgresql-42.1.4.jar) Thank you very much! Noelia
