Top
Enterprise Postgres 17 SP1 Installation and Setup Guide for Server

4.7.11 pgvector

Note that while OSS is named "pgvector", the binaries and the extensions themselves are named "vector".

It is not possible to data masking data added by pgvector using data masking features.

When using in-memory features, data types and functions added in pgvector cannot be accelerated.

4.7.11.1 Setting Up pgvector

  1. As superuser, run the following command:

    $ su -
    Password:******
    # cp -r /opt/fsepv<x>server64/OSS/pgvector/* /opt/fsepv<x>server64
  2. Execute CREATE EXTENSION for the database that will use this feature.
    Use the psql command to connect to the "postgres" database.

    postgres=# CREATE EXTENSION vector;
    CREATE EXTENSION

4.7.11.2 Removing pgvector

  1. Execute DROP EXTENSION for the database that will use this feature.
    Use the psql command to connect to the "postgres" database.

    postgres=# DROP EXTENSION vector CASCADE;
    DROP EXTENSION
  2. As superuser, run the following command:

    $ su -
    Password:******
    # rm -rf /opt/fsepv<x>server64/filesCopiedDuringSetup

    Information

    The files copied during setup can be checked below.

    # find /opt/fsepv<x>server64/OSS/pgvector