Hello Digital Ocean Community!
In my application the following usecase came up, that I would like to do long term data archiving on parts of my operational data in a managed postgresql cluster. I found the list of the supported extensions here in the docs.
I figured, that I would like to use Parquet files fora archiving and analytics in my s3 compatible (do spaces) storage. For that I need the following extension:
To configure this extension, you have to provide credentials for your object storage, which could be set from a config file
or environment variables
My question is the following:
pg_parquet
extensions is on the list? If it is, when can we expect it to be available? If not, can i configure it somehow myself?Thanks for your answers in advance! Best Regards Bendeguz
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Heya, @fullammo
pg_parquet
is indeed not natively supported on the PostgreSQL Managed Platform. The best thing to do to get your voice heard regarding this would be to head over to our Product Ideas board and post a new idea, including as much information as possible for what you’d like to see implemented.For the time being you can spin up a droplet and configure PostgreSQL and enable the extenions.
Regards