Re: Another way to do audit in DML operations in PostgreSQL >= 14

Поиск
Список
Период
Сортировка
От S Hoffman
Тема Re: Another way to do audit in DML operations in PostgreSQL >= 14
Дата
Msg-id 17797068-0325-47A4-AF8E-8CA820CB84E4@gmail.com
обсуждение исходный текст
Ответ на Re: Another way to do audit in DML operations in PostgreSQL >= 14  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Следующее
От: Sai Sadashiva Kundurmutt
Дата:
Сообщение: Are the estimates made for number of pages accurate