By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Aurora PostgreSQL aws_s3.query_export_to_s3 compression

2

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.

Topics
StorageDatabaseAnalytics
Tags
Amazon Simple Storage ServiceAurora PostgreSQLAmazon Aurora
Language
English
AWS-User-2961079
asked 2 years ago884 views
1 Answer
2

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.

AWS
SUPPORT ENGINEER
Arnab_S
answered 2 years ago
  • shaohong
    a year ago

    This would a really handy feature to export the data as gzipped file s3. Good for the environment!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content