amazon-archives / data-pipeline-samples

This repository hosts sample pipelines
MIT No Attribution
464 stars 269 forks source link

(DynamoDB->Redshift) Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. #80

Closed ghost closed 6 years ago

ghost commented 6 years ago

Hey, for the "RedshiftCopyActivityFromDynamoDBTable", I followed exactly the same steps as the sample. However, the pipeline is always give me an error of "ava.lang.RuntimeException: org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."

If I use SQL Bench with JDBC driver directly, the same command will work. It just doesn't work on AWS pipeline