README.md

docker-postgres-ai

This Docker images extends official Postgres docker image with the following extensions:

• PGVector
• VectorScale
• PGAI

Current state:

• Postgres 16.3 image with pgvector, pgai and vectorscale extension.

Getting started

Cmd to run this docker image

$ docker run -p 5432:5432 -e POSTGRES_PASSWORD=secretpassword jayachandhar/postgres:16.3

More environment variables can be set following the official postgres documentation.

Enable the PG extensions;

• Open a new terminal, and connect to postgres DB

  PGPASSWORD=secretpassword psql -h localhost -U postgres postgres

• Create the extension:

CREATE EXTENSION IF NOT EXISTS vector;
CREATE EXTENSION IF NOT EXISTS vectorscale;
CREATE EXTENSION IF NOT EXISTS plpython3u;
CREATE EXTENSION IF NOT EXISTS ai;

TODO

[ ] add usage example & sample queries.