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

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

주제

스토리지 컴퓨팅 데이터베이스 마이그레이션 및 현대화 분석

태그

아마존 심플 스토리지 서비스 아마존 Lightsail PostgreSQL 아마존 Relational Database Service

언어

English

peterkneale_cmri

질문됨 일 년 전297회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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-user-calma

답변함 일 년 전

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.

peterkneale_cmri

답변함 일 년 전

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

관련 콘텐츠