Re: postgres in swap space

2025-11-18 Thread Marc Millas
Clear ! thanks Laurentz Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Mon, Nov 17, 2025 at 9:50 PM Laurenz Albe wrote: > On Mon, 2025-11-17 at 18:25 +0100, Marc Millas wrote: > > Can someone point me to any doc describing why and how much space > postgres uses on the swap of a d

Re: Using pgAudit to audit interesting tables for all users except for batch user?

2025-11-18 Thread Colin 't Hart
Duh, I feel silly now :-) Works perfectly. Many thanks, Colin On Tue, 18 Nov 2025 at 16:11, Greg Sabino Mullane wrote: > On Tue, Nov 18, 2025 at 4:18 AM Colin 't Hart > wrote: > >> alter user set pgaudit.log to 'none'; >> > > That's close! pgaudit.log deals with session level things, but yo

Re: Using pgAudit to audit interesting tables for all users except for batch user?

2025-11-18 Thread Greg Sabino Mullane
On Tue, Nov 18, 2025 at 4:18 AM Colin 't Hart wrote: > alter user set pgaudit.log to 'none'; > That's close! pgaudit.log deals with session level things, but you want to exclude object-level things. Try: create role skip_pguadit; alter user set pgaudit.role = 'skip_pgaudit'; Cheers, Greg -

Using pgAudit to audit interesting tables for all users except for batch user?

2025-11-18 Thread Colin 't Hart
Hi, One of my clients has some tables that contain sensitive data. These are modified regularly by batch jobs, and then the data is transformed and summary information appended to other tables (fairly typical datawarehouse). For these sensitive tables they would like to add auditing of all activi