Can't connect to postgres using sqoop; HW Sandbox HDP 2.6.5

[#1]

Hi,

I have been trying to connect to postgres DB using sqoop so i can import a table from there to HDFS; however I keep getting errors and have tried variuos solutions online but none seem to work..

connection string =  sqoop list-tables --connect jdbc:postgresql://"ip of db or localhost":5432/postgres --username yomi --password mypassword

here below is the error im facing on putty and also my config file

the authentication type 10 is not supported. check that you have configured the pg_hba.conf file to include the client's ip address or subnet

pg_hba:

thanks in advance for the help!

[#2]

@yomz 
Can you adjust the below parameters restart Postgres and restest   

pg_hba.conf 

Spoiler

# TYPE      DATABASE             USER                   ADDRESS               METHOD

    host             all                           all                      0.0.0.0/0                     md5

Locate the postgresql.conf and add the below entry

Spoiler

password_encryption = md5

Please let me know

[#3]

thanks for response,, made the changes but still getting the error

[#4]

thanks for response,, made the changes but still getting the error