Two things.

First, running the installation commands as shown withsudo causes this warning:

WARNING: Running pip as the'root' user can resultin broken permissions and conflicting behaviour with the system package manager. It is recommended to use a virtual environment instead: https://pip.pypa.io/warnings/venv

Is it necessary to usesudo? Installation instructions that cause the system to emit warnings will worry people kicking the tires and will scare some of them away.

Second, and more important, after following the instructions to the letter, I get this error when trying to use transformers.

psql (14.6 (Ubuntu14.6-0ubuntu0.22.04.1))Type"help" for help.postgres=# SELECT pgml.transform('translation_en_to_fr',    inputs=> ARRAY['Welcome to the future!','Where have you been all this time?'    ])AS french;ERROR:  called`Result::unwrap()`on an`Err` value: PyErr { type:<class'ModuleNotFoundError'>, value: ModuleNotFoundError("No module named 'transformers'"), traceback: Some(<traceback object at 0x7fbaea7dc700>) }CONTEXT:  src/bindings/transformers.rs:19:62

This is for postgresql-14 and pgml-14 on Ubuntu 22.

1. Unfortunately, python dependency management is fraught with peril and installing in the system Python is required for Postgres to be able to find the modules for most generally distributed versions.

There may be ways we could get around this by using individual package managers (e.g. apt on debian/ubuntu) to install Python dependencies system wide, but we'd need documentation for every distribution and OS. I think a better path forward would be to sandbox the Postgres plPython dependencies (or at least just our own) using a virtualenv forpy03.

2. I think you need to also install the transformers pip package (and probably torch and/or tensorflow). I'll see what docs need to be updated.

Hello, would you please provide guidance on how to install postgresML extension on CentOS ? Many thanks !

Hi@ahmedrachid, we don't maintain a CentOS package, although you can convert thedeb package we distribute withalien. Otherwise, you'll need to build from source.