Top
Enterprise Postgres 18 Knowledge DataManagement FeatureUser's Guide

5.2.3 Removing

Before deleting this feature, unload and delete all models used by this feature from the inference server.

Unload model
SELECT pgx_inference.pgx_unload_all_models();

The unload process is performed asynchronously. Refer to the pgx_triton_model_status view to confirm that the unload process is complete.

Delete model

After unloading is complete, delete all models.

SELECT pgx_inference.pgx_drop_all_models();

After unloading and deleting all models, connect to the database where this feature is used and execute DROP EXTENSION.

DROP EXTENSION pgx_inference;

When using semantic text search and automatic vectorization features with pgx_vectorizer, execute DROP EXTENSION for pgx_vectorizer with the CASCADE option specified.

DROP EXTENSION pgx_vectorizer CASCADE;