Adding PgVector to an existing Postgres DB

[arpowers]

Just found this post:

Adding pgvector to Fly Postgres

Working with “vector” databases is extremely popular right now due to various AI and Machine Learning tasks they can help improve. Luckily the Supabase team open sourced their pgvector library to make storing and working with them built right into Postgres! Unfortunately the default Fly Postgres Image does not include it by default. So I set out to do this: Create a Dockerfile FROM flyio/postgres-flex:15.2 # Install build dependencies RUN apt-get update && \ apt-get install -y --no-instal…

But was wondering how I might add Pgvector to an existing Postgres database, with out much hassle (e.g. migration)…

Any thoughts?

[arpowers]

Ping