title: How to pull data from aws rds postgresql using kafka locally?
body: <p>I have postgresql database server on aws. I have setup one node kafka cluster on my local machine and want to pull data from postgresql database server. i have been using jdbc source connector here is the configuration(changed the actual values)</p>
  
  <pre><code>name=test-source-postgresql-jdbc-01
  connector.class=io.confluent.connect.jdbc.JdbcSourceConnector
  tasks.max=1
  key.converter=io.confluent.connect.avro.AvroConverter
  key.converter.schema.registry.url=http://localhost:8081
  connection.url=jdbc:postgresql://hostname:5432/dbname? 
  user=abc&amp;password=pwd
  connection.user=abc
  connection.password=pwd
  table.whitelist=abc1
  mode=timestamp
  timestamp.column.name=timestamp
  topic.prefix=test-postgresql-
  </code></pre>
  
  <p>and getting following error while running </p>
  
  <pre><code>ERROR Failed to create job for etc/kafka-connect-jdbc/quickstart-postgresql.properties (org.apache.kafka.connect.cli.ConnectStandalone:102)
  ERROR Stopping after connector error (org.apache.kafka.connect.cli.ConnectStandalone:113)
  java.util.concurrent.ExecutionException: org.apache.kafka.connect.runtime.rest.errors.BadRequestException: Connector 
  configuration is invalid and contains the following 2 error(s):
  Invalid value org.postgresql.util.PSQLException: Connection to hostname:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. for configuration Couldn't open connection to jdbc:postgresql://abc:5432/dbname?user=abc&amp;password=pwd
  </code></pre>
  
  <p>curl localhost:8083/connector-plugins<a href="https://i.stack.imgur.com/EeBvR.png" rel="nofollow noreferrer">Please click link</a></p>
  
  <p>ls share/java/kafka-connect-jdbc -l <a href="https://i.stack.imgur.com/wQk3n.png" rel="nofollow noreferrer">Please click link</a></p>
  
  <p>Any help would be appreciated!</p>