FATAL","58P01","could not access file ""pgaudit"": No such file or directory

Products

• VMware Tanzu Greenplum

Issue/Introduction

Unable to start Greenplum after updating the shared_preload_libraries by adding pgaudit as per the Documentation.

https://docs.vmware.com/en/VMware-Greenplum/6/greenplum-database/ref_guide-modules-pgaudit.html?hWord=N4IghgNiBcIA4HMwFcAmBLALiAvkA
 

gpadmin@dev-dbs01 ~]$ gpconfig -s shared_preload_libraries
Values on all segments are consistent
GUC : shared_preload_libraries
Master value: metrics_collector
Segment value: metrics_collector
[gpadmin@dev-dbs01 ~]$ gpconfig -c shared_preload_libraries -v 'pg_stat_statements,pgaudit'
20231005:10:52:52:003387 gpconfig:dev-dbs01:gpadmin-[INFO]:-completed successfully with parameters '-c shared_preload_libraries -v pg_stat_statements,pgaudit'
[gpadmin@dev-dbs01 ~]$ gpconfig -s shared_preload_libraries
Values on all segments are consistent
GUC : shared_preload_libraries
Master value: metrics_collector
Segment value: metrics_collector
[gpadmin@dev-dbs01 ~]$ gpstop -ar


/opt/greenplum/data1/gpsne0/postgresql.conf
/opt/greenplum/data2/gpsne1/postgresql.conf
/opt/greenplum/master/gpsne-1/postgresql.conf

pgaudit

 

2023-10-05 10:59:00.355483 +08,,,p4202,th1424929408,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""sweeper process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-10-05 10:59:00.355623 +08,,,p4202,th1424929408,,,,0,,,seg-1,,,,,"LOG","00000","registering background worker ""ic proxy process""",,,,,,,,"RegisterBackgroundWorker","bgworker.c",774,
2023-10-05 10:59:00.355723 +08,,,p4202,th1424929408,,,,0,,,seg-1,,,,,"FATAL","58P01","could not access file ""pgaudit"": No such file or directory",,,,,,,,"internal_load_library","dfmgr.c",202,1 0xbd6278 postgres errstart (elog.c:567)
2 0xbdb72d postgres <symbol not found> (dfmgr.c:199)
3 0xbdbdd4 postgres load_file (dfmgr.c:156)
4 0xbe5d9a postgres <symbol not found> (miscinit.c:1378)
5 0xbe6efe postgres process_shared_preload_libraries (miscinit.c:1399)
6 0xa16717 postgres PostmasterMain (postmaster.c:1152)
7 0x6dd78b postgres main (main.c:178)
8 0x7f4051723493 libc.so.6 __libc_start_main + 0xf3
9 0x6e946e postgres _start + 0x2e

Environment

Product Version: 6.25

Resolution

pgaudit is not supported until Greenplum 6.25.x and above.