Adding Pgvector to asdf

Problem

Look at you, juggling multiple Postgres versions with asdf and expecting things to just work. Surprise! pgvector has no idea which pg_config to use, so it’s throwing a tantrum.

Solution

Quit whining and specify the correct path. Here’s how:

git clone --branch v0.8.0 https://github.com/pgvector/pgvector.git
cd pgvector
export PG_CONFIG=$(asdf which pg_config)
make
make install

Now create extension:

CREATE EXTENSION IF NOT EXISTS vector;

Verify it:

SELECT extname
FROM pg_extension
WHERE extname = 'vector';