Top
Enterprise Postgres 17 Installation and Setup Guide for Server

4.6.5 pg_repack

4.6.5.1 Setting Up pg_repack

  1. As superuser, run the following command:

    $ su -
    Password:******
    # cp -r /opt/fsepv<x>server64/OSS/pg_repack/* /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 pg_repack;
    CREATE EXTENSION

4.6.5.2 Removing pg_repack

  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 pg_repack 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/pg_repack