search

fly-apps / postgres-ha

Postgres + Stolon for HA clusters as Fly apps.
Apache License 2.0
316 stars 131 forks source link

How to add extensions such as timescaledb? #67

Closed nunofgs closed 1 year ago

nunofgs commented 2 years ago

Any plans for easily adding extensions to the cluster?

dysinger commented 2 years ago

I also want this. I've been scouring the internet for info on adding extensions. It's common to need a little bit of packaging installed and some modifications to postgresql.conf to make it work. I'm not certain how this would be handled with fly's canned postgres

dysinger commented 2 years ago

It's not encouraging that this issue has sat unanswered since Apr 1 :(

tekacs commented 2 years ago

Same question here -- was looking to use pglogical (which is easily pulled from apt) to migrate from Google Cloud SQL, but the current situation would involve disabling the fly postgres commands by making a custom image. Would really appreciate some way to set the instance up with extension installation.

amrnt commented 1 year ago

why not to take a look at https://github.com/fly-apps/postgres-ha/pull/75? I have timescaledb up in no time!

The only backward is not being able to use fly pg commands

davissp14 commented 1 year ago

https://github.com/fly-apps/postgres-ha/pull/75