This is the initial version of an auditing module for Postgres.
It collects audit events from various sources and logs them in CSV format
including a timestamp, user information, details of objects affected (if any),
and the fully-qualified command text (whenever available).
All DDL, DML (including SELECT), and utility commands are supported. These
are categorised as described below, and audit logging for each group of
commands may be enabled or disabled by the superuser. Once enabled, however,
audit logging may not be disabled by a user.
Provides
Requires
License
PostgreSQL
Changelog
* Thu Sep 25 2025 mrueckert@suse.de
- Add support for pg 18 by adding the 18.0 version
- bug fixes:
- Error when required hooks are skipped.
- Improvements:
- SELECT FOR UPDATE object logging improvement.
- Disable logging in parallel workers.
- Use strpbrk() instead of strstr() where applicable.
- Fix search_path for trigger functions.
- Minor code optimizations.
- Features:
- PostgreSQL 18 support.
* Tue Jul 08 2025 max@suse.com
- Update to 17.1, 16.1, 1.7.1, 1.6.3, 1.5.3:
* Fix issues that could cause 'pgaudit stack is not empty' errors.
* Fri Feb 14 2025 max@suse.com
- Stop building for EOL postgresql12.
* Sat Sep 28 2024 mrueckert@suse.de
- Added version 17 for postgresql 17
https://github.com/pgaudit/pgaudit/releases/tag/16.0
* Fri May 17 2024 max@suse.com
- PostgreSQL 11 is EOL.
* Wed Sep 06 2023 mrueckert@suse.de
- Added version 16 for postgresql 16
https://github.com/pgaudit/pgaudit/releases/tag/16.0
* Wed Apr 19 2023 max@suse.com
- PostgreSQL 10 is EOL.
* Tue Jan 31 2023 mrueckert@suse.de
- added 1.7.0 to enable pg 15
* Thu Sep 22 2022 dimstar@opensuse.org
- Hack up spec file a bit to get over source_validator, we rely on
+ name_pg uses --keep-name-conditionals (argument of spec_query)
+ but wre also need pg_name defined for the pg_* macros, as they
refer to it. So we define both, and use name_pg for the
conditions.
* Mon Mar 21 2022 pgajdos@suse.com
- version update to 1.2.4, 1.3.4, 1.4.3, 1.5.2, 1.6.2
* Bug Fix: Skip logging script statements for create/alter extension.
- added sources
+ get-tars
* Thu Dec 02 2021 mrueckert@suse.de
- fix postgresql_has_llvm usage
* Tue Nov 30 2021 mrueckert@suse.de
- switch to %{pg_name}-llvmjit-devel
* Sun Nov 14 2021 mrueckert@suse.de
- remove some unneeded pg_name conditionals
* Sun Nov 14 2021 mrueckert@suse.de
- Update versions (1.2.3, 1.3.3, 1.4.2, 1.5.1)
- Guard against search-path based attacks.
- Add security definer and search_path to event trigger functions.
- Add 1.6.1 for postgresql 14
- 1.6.0: https://github.com/pgaudit/pgaudit/releases/tag/1.6.0
- 1.6.1: https://github.com/pgaudit/pgaudit/releases/tag/1.6.1
- port to postgresql macros
- drop support for pg < 10
* Wed Jun 30 2021 dimstar@opensuse.org
- Do no longer build postgresql95 and postgresql96 flavors on
Tumbleweed.
* Wed Nov 04 2020 pgajdos@suse.com
- try to make factory bot happy
* Tue Nov 03 2020 pgajdos@suse.com
- revert last change, keep flavours unresolved
* Wed Oct 21 2020 pgajdos@suse.com
- do not build favours that would be unresolved in standard repos
* Tue Oct 20 2020 pgajdos@suse.com
- version update
- 1.0.8: https://github.com/pgaudit/pgaudit/releases/tag/1.0.8
- 1.1.3: https://github.com/pgaudit/pgaudit/releases/tag/1.1.3
- 1.2.2: https://github.com/pgaudit/pgaudit/releases/tag/1.2.2
- 1.3.2: https://github.com/pgaudit/pgaudit/releases/tag/1.3.2
- 1.4.1: https://github.com/pgaudit/pgaudit/releases/tag/1.4.1
* Fri Sep 25 2020 mrueckert@suse.de
- added pg 13 support by adding 1.5.0
https://github.com/pgaudit/pgaudit/releases/tag/1.5.0
* Wed May 06 2020 mrueckert@suse.de
- we added support for newer pg versions but never enabled them in
the multibuild
* Tue Oct 22 2019 mrueckert@suse.de
- bump package for existing versions and add support for newer pg
versions:
- 1.0.7: https://github.com/pgaudit/pgaudit/releases/tag/1.0.7
- 1.1.2: https://github.com/pgaudit/pgaudit/releases/tag/1.1.2
- 1.2.1: https://github.com/pgaudit/pgaudit/releases/tag/1.2.1
- 1.3.1: https://github.com/pgaudit/pgaudit/releases/tag/1.3.1
- 1.4.0: https://github.com/pgaudit/pgaudit/releases/tag/1.4.0
* Fri Sep 08 2017 mrueckert@suse.de
- make the file lists less broad:
- BR the -server package so we get the owner of
%{_datadir}/pos