PostgreSQL extensions?

Is it possible to add extensions to a PostgreSQL cluster?

I’d love to continue leaning on Fly’s cluster deployment with just a touch of customization: installing an extension. Unfortunately, the one I’m looking at wants Go and gcc installed, but … yeah, anyway: PostgreSQL extensions?

The short answer is yes.

The longer answer is: Postgres clusters on Fly are just another app: GitHub - fly-apps/postgres-ha: Postgres + Stolon for HA clusters as Fly apps.

If you clone that repository, then run flyctl config save -a <your-pg-cluster-name>, you can make any changes you want to it and then run flyctl deploy.

2 Likes

Excellent. Thanks!

1 Like