pgml

pig build get pgml; # get pgml source code
pig build dep pgml; # install build dependencies
pig build pkg pgml; # build extension rpm or deb
pig build ext pgml; # build extension rpms

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

pig ext install pgml; # install by extension name, for the current active PG version
pig ext install pgml; # install via package alias, for the active PG version
pig ext install pgml -v 17;   # install for PG 17
pig ext install pgml -v 16;   # install for PG 16
pig ext install pgml -v 15;   # install for PG 15
pig ext install pgml -v 14;   # install for PG 14

CREATE EXTENSION pgml CASCADE SCHEMA pgml;

shared_preload_libraries: pgml, timescaledb, pg_stat_statements, auto_explain
pgml.venv: '/data/pgml'

CREATE EXTENSION vector;        -- nice to have pgvector installed too!
CREATE EXTENSION pgml;          -- create PostgresML in current database
SELECT pgml.version();          -- print PostgresML version string

# create extension pgml;
INFO:  Python version: 3.11.2 (main, Oct  5 2023, 16:06:03) [GCC 8.5.0 20210514 (Red Hat 8.5.0-18)]
INFO:  Scikit-learn 1.3.0, XGBoost 2.0.0, LightGBM 4.1.0, NumPy 1.26.1
CREATE EXTENSION

# SELECT pgml.version(); -- print PostgresML version string
 version
---------
 2.7.8