Aurora PostgreSQL aws_s3.query_export_to_s3 compression
Is there any way to compress s3 export data using aws_s3.query_export_to_s3 on Aurora PostgreSQL?
Redshift has various compression options in its UNLOAD command but I cannot see anything similar for Aurora PostgreSQL.
Thank you for reaching out. I understand you wanted to know if there is any options to compress data while exporting data to s3 using aws_s3.query_export_to_s3 on Aurora PostgreSQL.
Unfortunately, compression is not available in this feature set at this time.
However, I would suggest to keep an eye on our what's-new page, blogs for announcements about new features and improvements to RDS and other AWS services that might be of interest to you.
https://aws.amazon.com/new/#database-services https://aws.amazon.com/blogs/database/
As always, Happy Cloud Computing.
Relevant questions
Aurora PostgreSQL aws_s3.query_export_to_s3 compression
asked 2 months agoChoosing RDS PostgreSQL over Aurora PostgreSQL
asked 2 months agoTracking changes in data in Aurora PostgreSQL
Accepted Answerasked 2 years agoRDS Postgresql migrate to Aurora Postgresql. Not showing "Aurora read replica" & "Migrate snapshot" options.
Accepted Answerasked 5 months agoUse Aurora Postgresql as Datamart for Redshift
Accepted Answerasked 3 years agoParallel load support in aws_s3 extension to import data in Aurora PostgreSQL
Accepted AnswerInvoke lamda async from Aurora PostgreSQL
Accepted Answerasked 2 years agoMigration from Aurora PostgreSQL back to regular RDS
Accepted Answerasked 3 years agoMove RDS postgresql database to Aurora Serverless
Accepted Answerasked 3 years agoMajor Version Upgrade Aurora PostgreSQL 11
asked 2 years ago