Unable to start my Postgres database after adding pgaudit on my shared_preload_libraries

Question

I am getting these errors (please see below) after I restart my psql database. This occurs after i install pgaudit and adding pgaudit on my postgresql.conf. I wonder what am i missing, is it a problem on pgaudit installation?

2024-01-22 10:00:21.293 PST [3212773] FATAL:  58P01: could not access file "pgaudit": No such file or directory
2024-01-22 10:00:21.293 PST [3212773] LOCATION:  internal_load_library, dfmgr.c:210

pgaudit rpm

yum list pgaudit
Last metadata expiration check: 0:29:17 ago on Mon 22 Jan 2024 09:50:21 AM PST.
Installed Packages
pgaudit.x86_64                                                                 1.7.0-1.module+el8.9.0+90110+d8a562d5       

rpm -qa | grep pgaudit
pgaudit-1.7.0-1.module+el8.9.0+90110+d8a562d5.x86_64

OS details:

Operating System: Oracle Linux Server 8.6
Kernel: Linux 5.4.17-2136.310.7.el8uek.x86_64
Architecture: x86-64

psql version psql (15.3)

Answer 1

The first error could not access file "pgaudit": No such file or directory looks like you haven't installed pgaudit, but i see in the second snippet you have the right pgaudit version for your database version PostgreSQL 15.

I recommend you uninstall the current pgaudit and try installing it directly from the source code here.

Also ensure they are no errors in your postgresql.conf file.

Also, if you are using Greenplum, there is known compatibility issues with pgaudit not supported until Greenplum 6.25.x and above.

In addition, you can check out this detailed article on auditing a PostgreSQL DB. (Disclosure: I am affiliated with this site.)

Answer 2

Issue resolved. We only just need to download the correct rpms/package for pgaudit, i've noticed late that the installed postgresql15 was using 2GPGDG.rhel8 and not OEL. This is the correct package for RHEL8 pgaudit17_15-1.7.0-1.rhel8.x86_64.rpm. Thanks to @Kiki and @Erwin for the inputs.