PG won't start after shared_preload_libraries = set-user

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 postgresql@14-main.service failed because the service did not take the steps required by its unit configuration.

journalctl -xe shows:

postgresql@14-main[2387]: 2022-04-03 04:22:15 HST [2412]: 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?

1 Like

open the file /var/lib/pgsql/14/data/ and
please comment this line : shared_preload_libraries = ‘“set-user”’
and then you can restart the postgresql service sudo systemctl restart postgresql-14
it will work

1 Like