Created attachment 238574 [details] postgresql-pgaudit shar file. add postgresql-pgaudit port. the PostgreSQL Audit Extension (pgAudit) provides detailed session and/or object audit logging via the standard PostgreSQL logging facility.
The build failed, here is the last lines of the build log: Message from ccache-3.7.12_4: -- NOTE: Please read /usr/local/share/doc/ccache/ccache-howto-freebsd.txt for information on using ccache with FreeBSD ports and src. ===> postgresql13-pgaudit-1.7.0 depends on file: /usr/local/bin/ccache - found ===> Returning to build of postgresql13-pgaudit-1.7.0 =========================================================================== =======================<phase: lib-depends >============================ =========================================================================== =>> Recording filesystem state for prebuild... done =======================<phase: configure >============================ ===> postgresql13-pgaudit-1.7.0 depends on package: gmake>=4.3 - found ===> postgresql13-pgaudit-1.7.0 depends on executable: postgres - found ===> postgresql13-pgaudit-1.7.0 depends on file: /usr/local/bin/ccache - found ===> Configuring for postgresql13-pgaudit-1.7.0 =========================================================================== =======================<phase: build >============================ ===> Building for postgresql13-pgaudit-1.7.0 gmake[1]: Entering directory '/wrkdirs/usr/ports/databases/postgresql-pgaudit/work/pgaudit-1.7.0' cc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -Wno-unused-command-line-argument -Wno-compound-token-split-by-macro -O2 -pipe -fstack-protector-strong -fno-strict-aliasing -fPIC -DPIC -I. -I./ -I/usr/local/include/postgresql/server -I/usr/local/include/postgresql/internal -I/usr/local/include -I/usr/local/include -I/usr/local/include -c -o pgaudit.o pgaudit.c pgaudit.c:1582:62: error: too many arguments to function call, expected 7, have 8 params, queryEnv, dest, qc); ^~ pgaudit.c:1585:57: error: too many arguments to function call, expected 7, have 8 params, queryEnv, dest, qc); ^~ /usr/local/include/postgresql/server/tcop/utility.h:82:13: note: 'standard_ProcessUtility' declared here extern void standard_ProcessUtility(PlannedStmt *pstmt, const char *queryString, ^ pgaudit.c:2188:25: warning: incompatible function pointer types assigning to 'ProcessUtility_hook_type' (aka 'void (*)(struct PlannedStmt *, const char *, ProcessUtilityContext, struct ParamListInfoData *, struct QueryEnvironment *, struct _DestReceiver *, struct QueryCompletion *)') from 'void (PlannedStmt *, const char *, bool, ProcessUtilityContext, ParamListInfo, QueryEnvironment *, DestReceiver *, QueryCompletion *)' (aka 'void (struct PlannedStmt *, const char *, bool, ProcessUtilityContext, struct ParamListInfoData *, struct QueryEnvironment *, struct _DestReceiver *, struct QueryCompletion *)') [-Wincompatible-function-pointer-types] ProcessUtility_hook = pgaudit_ProcessUtility_hook; ^ ~~~~~~~~~~~~~~~~~~~~~~~~~~~ 1 warning and 2 errors generated. gmake[1]: *** [<builtin>: pgaudit.o] Error 1 gmake[1]: Leaving directory '/wrkdirs/usr/ports/databases/postgresql-pgaudit/work/pgaudit-1.7.0' ===> Compilation failed unexpectedly. Try to set MAKE_JOBS_UNSAFE=yes and rebuild before reporting the failure to the maintainer. *** Error code 1 Stop. make: stopped in /usr/ports/databases/postgresql-pgaudit build of databases/postgresql-pgaudit | postgresql13-pgaudit-1.7.0 ended at Thu Feb 2 13:58:08 CST 2023 build time: 00:00:18 !!! build failure encountered !!! [00:00:23] Error: Build failed in phase: build [00:00:23] Cleaning up [00:00:23] Unmounting file systems
A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=44da8f9536eabe9bfd8d4b8c01a3d8ffe44868b2 commit 44da8f9536eabe9bfd8d4b8c01a3d8ffe44868b2 Author: Wen Heping <wen@FreeBSD.org> AuthorDate: 2023-05-09 06:36:26 +0000 Commit: Wen Heping <wen@FreeBSD.org> CommitDate: 2023-05-09 06:36:26 +0000 databases/postgresql-pgaudit: New port PostgreSQL Audit Extension (pgAudit) provides detailed session and/or object audit logging via the standard PostgreSQL logging facility. PR: 268198 Reported by: gehaowu@bitmoe.com databases/Makefile | 1 + databases/postgresql-pgaudit/Makefile (new) | 27 +++++++++++++++++++++++++++ databases/postgresql-pgaudit/distinfo (new) | 3 +++ databases/postgresql-pgaudit/pkg-descr (new) | 2 ++ 4 files changed, 33 insertions(+)