title: Microsoft Azure HDinsight Ambari Sqoop and Postgres
body: <p>Trying to import data from postgres into hdfs on Microsoft Azure HDInsigt. Now i started with a very simple command if listing dbs</p>
  
  <pre><code>sqoop list-databases --connect jdbc.postgresql://xx.xxx.xxx.xxx:yyyy --username myuser --password mypassword
  </code></pre>
  
  <p>i get the following error </p>
  
  <pre><code>ERROR tool.BaseSqoopTool: Got error creating database manager: java.io.IOException: No manager for connect string: jdbc.postgresql://52.178.204.150:4321
      at org.apache.sqoop.ConnFactory.getManager(ConnFactory.java:191)
      at org.apache.sqoop.tool.BaseSqoopTool.init(BaseSqoopTool.java:257)
      at org.apache.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:44)
      at org.apache.sqoop.Sqoop.run(Sqoop.java:148)
      at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
      at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
      at org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
      at org.apache.sqoop.Sqoop.main(Sqoop.java:244)
  </code></pre>
  
  <p>I tried adding the following args </p>
  
  <pre><code>--libjars=/usr/share/java/postgresql-jdbc4.jar
  --driver org.postgresql.Driver 
  --connection-manager org.apache.sqoop.manager.GenericJdbcManager
  </code></pre>
  
  <p>These still do not help the HDInsight manual only gives an example to use Microsoft SQL.</p>