Re: Another way to do audit in DML operations in PostgreSQL >= 14 - Mailing list pgsql-admin

From S Hoffman
Subject Re: Another way to do audit in DML operations in PostgreSQL >= 14
Date
Msg-id 17797068-0325-47A4-AF8E-8CA820CB84E4@gmail.com
Whole thread Raw
In response to Re: Another way to do audit in DML operations in PostgreSQL >= 14  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
A remote syslog is a good option, too. The method depends on the specific needs, resources, and infrastructure. Remote
Syslogcan be easier to set up. External logging solutions scale better, offer more analytical features, and can
allocatemore resources to log management. 

Try testing these approaches in a staging environment to assess their impact on performance and to ensure they meet
complianceneeds. That will be the best approach to determine the most beneficial solution. 

Kind regards,
Sondra

Sent from my iPhone

> On Feb 23, 2024, at 6:29 AM, Bruce Momjian <bruce@momjian.us> wrote:
>
> On Thu, Feb 22, 2024 at 08:54:52PM -0800, S Hoffman wrote:
>> Hi Lucio Chiessi,
>>
>> Dealing with large volumes of data can be a challenging task. If you struggle
>> with this issue, one possible solution is to consider using external logging
>> services. Specifically, asynchronous logging services or external logging
>> services that are designed to handle streaming data may be effective options to
>> explore. Some popular external logging services in this regard include
>> Elasticsearch and Spunk, known for their ability to handle large volumes of
>> data. If you have any questions or want to explore other options, please let me
>> know.
>
> Would remote syslog be an option too?
>
> --
>  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
>  EDB                                      https://enterprisedb.com
>
>  Only you can decide what is important to you.



pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Next
From: Sai Sadashiva Kundurmutt
Date:
Subject: Are the estimates made for number of pages accurate