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
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
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
-
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