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)
2
Answers
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.
The first error
could not access file "pgaudit": No such file or directory
looks like you haven’t installedpgaudit
, but i see in the second snippet you have the rightpgaudit
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.
I hope all these helps.