1 Answer
- Newest
- Most votes
- Most comments
0
Please see these articles related to PostgreSQL and DMS
- Using PostgreSQL as a Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html
- Using PostgreSQL as a Target: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html
Also check the replication instance itself to see which subnet it was launched in and if that corresponding subnet has connectivity to the source and target.
Relevant content
- asked a year ago
- asked 10 months ago
- AWS OFFICIALUpdated 7 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated 2 years ago
UPDATE: New error for source endpoint test: Connection refused Is the server running on host "my-host" and accepting TCP/IP connections on port 5432?
Hello, thank you for the above links. I was using PostgreSQL version 16 which is not listed on the above links you sent, so I created new instances for Postgres 15 instead but it still didn't work. I did also check the replication instance subnet and it does have connectivity to the source & target (NACLs and Security groups have the correct rules). Any other ideas by any chance?