Skip to content

Installing pgEdge Vectorizer

Before installing pgEdge Vectorizer, you need to install:

  • a Postgres server, version 14 or above
  • libcurl4-openssl-dev (the cURL library)
  • pgVector

Then, to build Vectorizer:

Clone the pgedge-vectorizer repository, and move into the repository root:

git clone https://github.com/pgEdge/pgedge-vectorizer.git
cd pgedge-vectorizer

Then, use the make and make install commands to build Vectorizer:

make
sudo make install

Use your choice of API tooling to create an API key file named pgedge-vectorizer-llm-api-key:

echo "your-api-key" > ~/.pgedge-vectorizer-llm-api-key
chmod 600 ~/.pgedge-vectorizer-llm-api-key

Then, modify the postgresql.conf file, adding the Vectorizer extension and API key file details:

shared_preload_libraries = 'pgedge_vectorizer'
pgedge_vectorizer.provider = 'openai'
pgedge_vectorizer.api_key_file = '~/.pgedge-vectorizer-llm-api-key'
pgedge_vectorizer.model = 'text-embedding-3-small'
pgedge_vectorizer.databases = 'mydb'  # Comma-separated list of databases to monitor

Restart PostgreSQL; then use your Postgres client to create the vector and pgedge-vectorizer extensions:

CREATE EXTENSION vector;
CREATE EXTENSION pgedge_vectorizer;