Configuring pgaudit

1. In postgresql.conf, add pgaudit to the shared_preload_libraries parameter:

   → WrapCopy

   shared_preload_libraries = 'pgaudit'

   If shared_preload_libraries has other extensions, then you can add pgaudit to the list. The order doesn't matter.

2. Restart Postgres.

3. Create the pgaudit extension in your database:

   → WrapCopy

   CREATE EXTENSION pgaudit;

For detailed information on other configuration steps, see the official pgaudit documentation.