The DMS replication instance connect to the RDS instance in different VPC failed but when I troubleshoot the issue by creating an EC2 in the same subnet with the DMS replication instance I could telnet, nslookup , psql connect to the RDS instance successfully...really confusing...
The error messages when DMS instance connects to RDS instance in different VPC:
Test Endpoint failed: Application-Status: 1020912, Application-Message: Cannot connect to ODBC provider Network error has occurred, Application-Detailed-Message: RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: [unixODBC]could not connect to server: No route to host Is the server running on host "pgdb.cf1p5lx4ynpa.us-west-2.rds.amazonaws.com" (192.168.0.131) and accepting TCP/IP connections on port 5432? ODBC general error. Cannot connect to ODBC provider Network error has occurred RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: [unixODBC]could not connect to server: No route to host Is the server running on host "pgdb.cf1p5lx4ynpa.us-west-2.rds.amazonaws.com" (192.168.0.131) and accepting TCP/IP connections on port 5432? ODBC general error. Cannot connect to ODBC provider Network error has occurred RetCode: SQL_ERROR SqlState: 08001 NativeError: 101 Message: [unixODBC]could not connect to server: No route to host Is the server running on host "pgdb.cf1p5lx4ynpa.us-west ```
