pgvector extension for Postgres

[spy16]

Hello!

Is there a way to install & enable pgvector extension on Fly.io ?

I think I know it’s possible since postgres on fly is just another app. Just wondering how would I actually set this up.

[jphenow]

If you need extra extensions, you can actually fork our app and deploy update your own postgres with your forked image.

Once the image is built and pushed, you’d do something like:

fly deploy . --image yourimageref

Then you probably need to hop into your pg instance using fly pg connect and run

CREATE EXTENSION pgvector;