Running a dms job from s3 to rds postgres instance

0

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 dbthis is the dms log message screenshot

質問済み 1年前371ビュー
1回答
0

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 :)

profile pictureAWS
サポートエンジニア
Brandon
回答済み 1年前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ