Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Running a dms job from s3 to rds postgres instance
Hi there, i am currently running a dms job from s3 to postgres instance, the dms runs successfully but the csv files is not being picked up by dms although the schema and table is automatically created on the postgres db
- Newest
- Most votes
- Most comments
Hi there,
Are there any error messages in the logs that you can see? This could be a configuration issue, can you check that you've implemented the correct naming conventions and table definitions as seen here - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.S3.html#CHAP_Source.S3.Configuring
This guide also provides information on using PostgreSQL as a target DB - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html
Another way you can import csv files to PostgreSQL is using the S3 extension which may be easier for you. See here for the guide on how to use it - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html
I hope that helps :)
Relevant content
- asked 2 years ago
