Is it possible to deploy Fly.io’s managed Postgres with pgvector available for installation (via CREATE EXTENSION) with zero end-user intervention?

,
1

We’re building a hands-free installer for GoodMem on fly.io that deploys a Postgres instance automatically.

Today, we deploy Postgres using a custom image (pgvector/pgvector:pg17) so that pgvector is guaranteed to be available, and our server installs the extension automatically on first startup.

We’d prefer to use Fly.io’s managed Postgres offering, but only if there’s a way to ensure that pgvector is already available in the managed Postgres instance, so that CREATE EXTENSION vector; succeeds without any manual steps.

Questions:

  1. Does Fly.io managed Postgres currently ship with pgvector available?

  2. If not, is there a supported or planned mechanism to enable extensions like pgvector non-interactively at provision time?

Happy to adapt our installer if there’s a recommended pattern here.

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.