From: S Hoffman <hoffman7043@gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (1.0)
Subject: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Date: Fri, 23 Feb 2024 11:35:04 -0800
Message-Id: <17797068-0325-47A4-AF8E-8CA820CB84E4@gmail.com>
References: <ZdiryzCPve7wcZIC@momjian.us>
Cc: Lucio Chiessi <lucio.chiessi@trustly.com>,
 PGSql Admin list <pgsql-admin@lists.postgresql.org>
In-Reply-To: <ZdiryzCPve7wcZIC@momjian.us>
To: Bruce Momjian <bruce@momjian.us>
Archived-At: 
 <https://www.postgresql.org/message-id/17797068-0325-47A4-AF8E-8CA820CB84E4%40gmail.com>
Precedence: bulk

A remote syslog is a good option, too. The method depends on the specific ne=
eds, resources, and infrastructure. Remote Syslog can be easier to set up. E=
xternal logging solutions scale better, offer more analytical features, and c=
an allocate more resources to log management.

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

Kind regards,
Sondra

Sent from my iPhone

> On Feb 23, 2024, at 6:29=E2=80=AFAM, Bruce Momjian <bruce@momjian.us> wrot=
e:
>=20
> =EF=BB=BFOn Thu, Feb 22, 2024 at 08:54:52PM -0800, S Hoffman wrote:
>> Hi Lucio Chiessi,
>>=20
>> Dealing with large volumes of data can be a challenging task. If you stru=
ggle
>> with this issue, one possible solution is to consider using external logg=
ing
>> services. Specifically, asynchronous logging services or external logging=

>> services that are designed to handle streaming data may be effective opti=
ons to
>> explore. Some popular external logging services in this regard include
>> Elasticsearch and Spunk, known for their ability to handle large volumes o=
f
>> data. If you have any questions or want to explore other options, please l=
et me
>> know.
>=20
> Would remote syslog be an option too?
>=20
> --
>  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
>  EDB                                      https://enterprisedb.com
>=20
>  Only you can decide what is important to you.