Top
Enterprise Postgres 17 SP1 Installation and Setup Guide for Server

4.7.12 pgvectorscale

Note that while OSS is named "pgvectorscale", the binaries and the extensions themselves are named "vectorscale".

4.7.12.1 Setting Up pgvectorscale

  1. As superuser, run the following command:
    Since pgvectorscale depends on pgvector, it copies pgvector as well.

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

    postgres=# CREATE EXTENSION IF NOT EXISTS vectorscale CASCADE;
    CREATE EXTENSION

4.7.12.2 Removing pgvectorscale

  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 vectorscale;
    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/pgvectorscale