tembo-io / pg_tier

Postgres Extension written in Rust, to enable data tiering to AWS S3
Apache License 2.0
109 stars 2 forks source link

RDS support? #9

Open horrendo opened 2 months ago

horrendo commented 2 months ago

Hi. Have you had any discussion with the RDS team about getting this extension added to the list of supported extensions for RDS?

ChuckHend commented 2 months ago

I am not 100% certain, but I believe RDS has some private extensions to do this on their platform. Ideally we could find a way to run those extensions places other than AWS. If not, then that is what this extension is for :)

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/postgresql-s3-export.html

horrendo commented 2 months ago

Thanks @ChuckHend , but as far as I can tell, that extension is simply for exporting to or importing from s3, and is not a foreign data wrapper like your extension. I think your extension is much more useful when it comes to data that may no longer need to be accessed as quickly as in-database storage, but still appearing to the application as accessible via SQL.