AWS Lightsail Databases: Loading data from s3 into Postgres using the aws_s3 postgres extension.

0

Previously, using AWS RDS for Postgres, I have loaded data directly from s3 buckets into psotgres database tables using functions such as aws_s3.table_import_from_s3

Does this same functionality exist when using a AWS Lightsail postgres database instance. I ask because while I can see the extensions when listing all available postgres extensions but am unable to invoke it.

Reference to the RDS documentation: (I am unable to find a lightsail equivalent) https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PostgreSQL.S3Import.html

2回答
0

Have you tried enabling VPC Peering? It enabled AWS resources outside of Amazon Lightsail: https://lightsail.aws.amazon.com/ls/docs/en_us/articles/lightsail-how-to-set-up-vpc-peering-with-aws-resources

AWS
回答済み 1年前
0

Thanks but per that link it isnt necessary

Some AWS resources, such as Amazon S3, Amazon CloudFront, and Amazon DynamoDB don't require VPC peering to be enabled.
回答済み 1年前

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

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

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

関連するコンテンツ