MIME-Version: 1.0
References: <CAD5k+7zxAmkoOeVq61gqg1xWu8egSjcRtAT=rrAF=ihxUjdTMQ@mail.gmail.com>
In-Reply-To: <CAD5k+7zxAmkoOeVq61gqg1xWu8egSjcRtAT=rrAF=ihxUjdTMQ@mail.gmail.com>
From: =?UTF-8?B?S0VOQU4gw4fEsEZUw4fEsA==?= <kciftci89@gmail.com>
Date: Tue, 15 Apr 2025 14:14:03 +0300
Message-ID: <CAHsK0FqMEoZ_EL6bdHL=MO6irp3uXa5iC_T9jKuCgwRcOQ=Feg@mail.gmail.com>
Subject: Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
To: vijay patil <vijay.postgres@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ce03990632cf44e4"
Archived-At: <https://www.postgresql.org/message-id/CAHsK0FqMEoZ_EL6bdHL%3DMO6irp3uXa5iC_T9jKuCgwRcOQ%3DFeg%40mail.gmail.com>
Precedence: bulk

--000000000000ce03990632cf44e4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi,

You can use pgaudit and pgauditlogtofile extension (
https://github.com/fmbiete/pgauditlogtofile) together to write audit logs
in a separate file.

yours,

Kenan =C3=87ift=C3=A7i

On Tue, Apr 15, 2025 at 1:44=E2=80=AFPM vijay patil <vijay.postgres@gmail.c=
om>
wrote:

> Hi All,
>
> We are exploring auditing solutions for our PostgreSQL database and are
> considering using pgaudit for this purpose. However, we have a few
> questions:
>
>    1.
>
>    *What is the best tool for auditing PostgreSQL databases?*
>    -
>
>       We are specifically looking for a solution that offers detailed
>       auditing capabilities and is compatible with our setup.
>       2.
>
>    *Can we store the audit information separately from PostgreSQL logs if
>    we decide to use pgaudit?*
>    -
>
>       We would prefer to keep the audit logs in a separate file or
>       location for easier management and analysis.
>
>
> We appreciate any help or suggestions!
>
>
> Thanks
>
> Vijay
>

--000000000000ce03990632cf44e4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div>You can use pgaudit and pgauditlogt=
ofile extension (<a href=3D"https://github.com/fmbiete/pgauditlogtofile">ht=
tps://github.com/fmbiete/pgauditlogtofile</a>) together=C2=A0to write audit=
 logs in a separate=C2=A0file.=C2=A0</div><div><br></div><div>yours,</div><=
div><br></div><div>Kenan =C3=87ift=C3=A7i</div></div><br><div class=3D"gmai=
l_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue=
, Apr 15, 2025 at 1:44=E2=80=AFPM vijay patil &lt;<a href=3D"mailto:vijay.p=
ostgres@gmail.com">vijay.postgres@gmail.com</a>&gt; wrote:<br></div><blockq=
uote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1p=
x solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr=
"><p>Hi All,</p><p>We are exploring auditing solutions for our PostgreSQL d=
atabase and are considering using <code>pgaudit</code> for this purpose. Ho=
wever, we have a few questions:</p>
<ol>
<li>
<p><strong>What is the best tool for auditing PostgreSQL databases?</strong=
></p>
<ul>
<li>
<p>We are specifically looking for a solution that offers detailed auditing=
 capabilities and is compatible with our setup.</p>
</li>
</ul>
</li>
<li>
<p><strong>Can we store the audit information separately from PostgreSQL lo=
gs if we decide to use <code>pgaudit</code>?</strong></p>
<ul>
<li>
<p>We would prefer to keep the audit logs in a separate file or location fo=
r easier management and analysis.</p>
</li>
</ul>
</li>
</ol>
<p><br></p>
<p>We appreciate any help or suggestions!</p><p><br></p><p>Thanks</p><p>Vij=
ay</p></div></div>
</blockquote></div>

--000000000000ce03990632cf44e4--