I am following the enabling extensions portion of the percona-postgresql-14 installation doc. For pgAudit set-user I run
ALTER SYSTEM SET shared_preload_libraries = ‘set-user’;
Attempting to reload postgres and it fails with this error message:
Job for firstname.lastname@example.org failed because the service did not take the steps required by its unit configuration.
journalctl -xe shows:
postgresql@14-main: 2022-04-03 04:22:15 HST : FATAL: could not access file “set-user”: No such file or directory
pgaudit/set_user github is calling it “set_user”. I was able to get it to work when specifying “set_user”, but on an installation with an identical percona-postgresql-14 I was able to “set-user”
How can I test to make sure my pgaudit setuser extension is working on both installations?