title: Connection in Pentaho with PostgreSQL
body: <p>I have the driver <strong>postgresql-9.3-1103.jdbc3.jar</strong>  in
  folder ...data-integration\lib and classpah is configured too</p>
  
  <p>I have the postgresql 9.3 Installed and i have the db prueba in postgresql
  but this is the error</p>
  
  <pre><code>Error connecting to database [PostgresDB] : org.pentaho.di.core.exception.KettleDatabaseException: 
  Error occurred while trying to connect to the database
  
  Error connecting to database: (using class org.postgresql.Driver)
  Invalid connection URL url jdbc:postgresql://localhost:5432/prueba
  
  org.pentaho.di.core.exception.KettleDatabaseException: 
  Error occurred while trying to connect to the database
  
  Error connecting to database: (using class org.postgresql.Driver)
  Invalid connection URL url jdbc:postgresql://localhost:5432/prueba
  
  at org.pentaho.di.core.database.Database.normalConnect(Database.java:428)
  at org.pentaho.di.core.database.Database.connect(Database.java:358)
  at org.pentaho.di.core.database.Database.connect(Database.java:311)
  at org.pentaho.di.core.database.Database.connect(Database.java:301)
  at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)
  at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2686)
  at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:546)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
  at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
  at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
  at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)
  at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:138)
  at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
  at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
  at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
  at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
  at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
  at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
  at org.eclipse.jface.window.Window.open(Window.java:796)
  at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:389)
  at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:318)
  at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)
  at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:59)
  at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.editConnection(SpoonDBDelegate.java:87)
  at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:3084)
  at org.pentaho.di.ui.spoon.Spoon.doubleClickedInTree(Spoon.java:3019)
  at org.pentaho.di.ui.spoon.Spoon.access$2400(Spoon.java:345)
  at org.pentaho.di.ui.spoon.Spoon$27.widgetDefaultSelected(Spoon.java:6113)
  at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
  at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
  at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
  at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
  at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
  at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319)
  at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939)
  at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190)
  at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  at java.lang.reflect.Method.invoke(Unknown Source)
  at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
  
  Caused by: org.pentaho.di.core.exception.KettleDatabaseException: 
  Error connecting to database: (using class org.postgresql.Driver)
  Invalid connection URL url jdbc:postgresql://localhost:5432/prueba
  
  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:594)
  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:4697)
  at org.pentaho.di.core.database.Database.normalConnect(Database.java:414)
  ... 45 more
  
  Caused by: java.lang.IllegalArgumentException: Invalid connection URL url jdbc:postgresql://localhost:5432/prueba
  at org.mariadb.jdbc.JDBCUrl.parse(JDBCUrl.java:144)
  at org.mariadb.jdbc.Driver.connect(Driver.java:95)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:574)
  ... 47 more
  </code></pre>
  
  <p>Hostname       : localhost
  Port           : 5432
  Database name  : prueba</p>