Top
Enterprise Postgres 17 SP1 Installation and Setup Guide for Server

4.7.13 Apache AGE

4.7.13.1 Setting Up Apache AGE

  1. As superuser, run the following command:

    $ su -
    Password:******
    # cp -r /opt/fsepv<x>server64/OSS/age/* /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 age;
    CREATE EXTENSION
  3. To use Apache AGE, execute a LOAD statement for each session, or add "age" to session_preload_libraries in postgresql.conf.

    postgres=# LOAD 'age';
    LOAD

4.7.13.2 Removing Apache AGE

  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 age;
    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/age