Top
Enterprise Postgres 17 Installation and Setup Guide for Server

4.6.11 pgvector

4.6.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

Note

  • 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.6.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