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

Question

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

Answer

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

Answer

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.
```

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

相關內容