I had same issue on MAC. it was resolved by copying the vector-0.8.0.sql file into extension folder. command :
sudo cp /tmp/pgvector/sql/vector--0.8.0.sql /Library/PostgreSQL/17/share/postgresql/extension/