[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: pg-audit extension
From:       Vijaykumar Jain <vijaykumarjain.github () gmail ! com>
Date:       2021-07-27 6:31:25
Message-ID: CAM+6J95_WG3U4P4dG42sBmL43eAqkrx_VtS49eQTDTAv-9_E=w () mail ! gmail ! com
[Download RAW message or body]

On Mon, Jul 26, 2021, 11:54 PM Olagoke Akinyemi <sahoong@yahoo.co.uk> wrote:

> Hello,
>
>
> Could someone please, give me a quick guide? I am trying to install
> pgaudit extension on an existing PostgreSQL instance but I want to place it
> on a different this mount. How can i do this?
>
> Are you trying to save pgaudit logs on a different location/ separate
mount?

> pgaudit would log audit stuff to the same log file to which postmaster is
configured to log.
https://www.postgresql.org/docs/14/runtime-config-logging.html

https://github.com/pgaudit/pgaudit/blob/master/README.md

> I can be corrected, but I am not sure you can log to a standalone location
different from postgresql logs.
But if your concern is, if, incase of a crash you would lose your audit
logs, them in my personal opinion, you can either use rsyslog or use
something like filebeat to monitor changes to log file and send changes to
a centralized setup.
If I misunderstood you, ignore my suggestions.

[Attachment #3 (text/html)]

<div dir="auto"><br><br><div class="gmail_quote" dir="auto"><div dir="ltr" \
class="gmail_attr">On Mon, Jul 26, 2021, 11:54 PM Olagoke Akinyemi &lt;<a \
href="mailto:sahoong@yahoo.co.uk" rel="noreferrer noreferrer noreferrer noreferrer \
noreferrer" target="_blank">sahoong@yahoo.co.uk</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div style="font-family:Helvetica \
Neue,Helvetica,Arial,sans-serif;font-size:13px" dir="auto"><div \
dir="ltr">Hello,</div><div dir="ltr"><br></div><div dir="ltr"><br></div><div \
dir="ltr">Could someone please, give me a quick guide? I am trying to install pgaudit \
extension on an existing PostgreSQL instance but I want to place it on a different \
this mount. How can i do this?  </div><div \
dir="ltr"><br></div></div></blockquote></div><div dir="auto">Are you trying to save \
pgaudit logs on a different location/ separate mount?</div><div class="gmail_quote" \
dir="auto"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div style="font-family:Helvetica \
Neue,Helvetica,Arial,sans-serif;font-size:13px" dir="auto"><div \
dir="ltr"></div></div></blockquote></div><div dir="auto">pgaudit would log audit \
stuff to the same log file to which postmaster is configured to log.</div><div \
dir="auto"><a href="https://www.postgresql.org/docs/14/runtime-config-logging.html" \
rel="noreferrer noreferrer" \
target="_blank">https://www.postgresql.org/docs/14/runtime-config-logging.html</a><br></div><div \
dir="auto"><br></div><div dir="auto"><a \
href="https://github.com/pgaudit/pgaudit/blob/master/README.md" target="_blank" \
rel="noreferrer">https://github.com/pgaudit/pgaudit/blob/master/README.md</a><br></div><div \
class="gmail_quote" dir="auto"><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="font-family:Helvetica \
Neue,Helvetica,Arial,sans-serif;font-size:13px" dir="auto"><div \
dir="ltr"></div></div></blockquote></div><div dir="auto">I can be corrected, but I am \
not sure you can log to a standalone location different from postgresql \
logs.</div><div dir="auto">But if your concern is, if, incase of a crash you would \
lose your audit logs, them in my personal opinion, you can either use rsyslog or use \
something like filebeat to monitor changes to log file and send changes to a \
centralized setup.</div><div dir="auto">If I misunderstood you, ignore my \
suggestions.</div><div dir="auto"><br></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]