Top
Enterprise Postgres 17 Security Operation Guide

6.10 Removing Setup

This section describes how to remove the setup of pgaudit.

  1. Start the instance

  2. Remove the pgaudit extension

    Execute DROP EXTENSION to remove the pgaudit extension from the database.

    $ psql -d <database name>
    =# DROP EXTENSION pgaudit;
    =# \q
  3. Change postgresql.conf

    Remove the parameters below relating to pgaudit.

    • shared_preload_libraries

    • pgaudit.config_file

  4. Restart the instance

  5. Remove the pgaudit files

    LinuxAs superuser, run the following command. Note that "<x>" in paths indicates the product version.

    $ 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/pgaudit

    WindowsOpen a command prompt as administrator privileges, run the following command. Note that "<x>" in paths indicates the product version.

    > del "c:\Program Files\Fujitsu\fsepv<x>server64\filesCopiedDuringSetup"

    Information

    The files copied during setup can be checked below.

    > dir /b /s "c:\Program Files\Fujitsu\fsepv<x>server64\OSS\pgaudit"