MIME-Version: 1.0
References: <CAD5k+7zxAmkoOeVq61gqg1xWu8egSjcRtAT=rrAF=ihxUjdTMQ@mail.gmail.com>
 <CAHsK0FqMEoZ_EL6bdHL=MO6irp3uXa5iC_T9jKuCgwRcOQ=Feg@mail.gmail.com>
In-Reply-To: <CAHsK0FqMEoZ_EL6bdHL=MO6irp3uXa5iC_T9jKuCgwRcOQ=Feg@mail.gmail.com>
From: vijay patil <vijay.postgres@gmail.com>
Date: Wed, 16 Apr 2025 10:45:24 +0530
Message-ID: <CAD5k+7zAUf827FLUnoYYFdd0YoD1Vmqz-QfmTMT5dgQu8KNKoQ@mail.gmail.com>
Subject: Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
To: =?UTF-8?B?S0VOQU4gw4fEsEZUw4fEsA==?= <kciftci89@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000eccd50632de60cc"
Archived-At: <https://www.postgresql.org/message-id/CAD5k%2B7zAUf827FLUnoYYFdd0YoD1Vmqz-QfmTMT5dgQu8KNKoQ%40mail.gmail.com>
Precedence: bulk

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

Hi Kenan,

Thanks for the quick response.

Thanks
Vijay

On Tue, Apr 15, 2025 at 4:44=E2=80=AFPM KENAN =C3=87=C4=B0FT=C3=87=C4=B0 <k=
ciftci89@gmail.com> wrote:

> 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=
.com>
> 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
>>
>

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

<div dir=3D"ltr"><div>Hi Kenan,</div><div><br></div><div dir=3D"ltr">Thanks=
 for the quick response.=C2=A0</div><div dir=3D"ltr"><br></div><div>Thanks<=
/div><div>Vijay</div><br><div class=3D"gmail_quote gmail_quote_container"><=
div dir=3D"ltr" class=3D"gmail_attr">On Tue, Apr 15, 2025 at 4:44=E2=80=AFP=
M KENAN =C3=87=C4=B0FT=C3=87=C4=B0 &lt;<a href=3D"mailto:kciftci89@gmail.co=
m">kciftci89@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><div dir=3D"ltr">Hi,<div><br></div><div>You can use p=
gaudit and pgauditlogtofile extension (<a href=3D"https://github.com/fmbiet=
e/pgauditlogtofile" target=3D"_blank">https://github.com/fmbiete/pgauditlog=
tofile</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=87if=
t=C3=A7i</div></div><br><div class=3D"gmail_quote"><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.postgres@gmail.com" target=3D"_blank">vijay.postgres@g=
mail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D=
"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-le=
ft:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><p>Hi All,</p><p>We are exploring=
 auditing solutions for our PostgreSQL database and are considering using <=
code>pgaudit</code> for this purpose. However, 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>
</blockquote></div></div>

--0000000000000eccd50632de60cc--