[
https://issues.apache.org/jira/browse/SQOOP-1559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14157855#comment-14157855
]
Chiwan Park commented on SQOOP-1559:
------------------------------------
Default, remote access to postgresql is prohibited. In this case, sqoop
mapreduce cannot access postgresql. You should check pg_hba.conf to enable
remote access.
http://www.postgresql.org/docs/9.3/static/auth-pg-hba-conf.html
> Unable to import data from Postgresql to HBase
> ----------------------------------------------
>
> Key: SQOOP-1559
> URL: https://issues.apache.org/jira/browse/SQOOP-1559
> Project: Sqoop
> Issue Type: Task
> Components: connectors/postgresql
> Affects Versions: 1.4.4
> Environment: Cent OS, rackspace cloud, Hadoop version:2.4.0
> Reporter: George Jaffa
> Labels: sqoop
> Original Estimate: 4h
> Remaining Estimate: 4h
>
> Trying to import data from Postgresql to HDFS by using sqoop. The relevant
> connector was placed at correct path but still unable to import the data.
> Command used:
> sqoop import --connect jdbc:postgresql://xxx.xx.xxx.xxx:5432/core --username
> root --password xxxxxxxxxx --table channels
> Error:
> ERROR manager.SqlManager: Error executing statement:
> org.postgresql.util.PSQLException: FATAL: role "root" does not exist
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
