Обсуждение: Question about pgaudit and the logfile

On Tue, Oct 15, 2019 at 11:25 AM M Jane <mskiesewetter@gmail.com> wrote:
> I am looking into the pgaudit extension and I have read in the readme file that the audit logging is being written to
thealertlog of the Postgresql instance.
 
> Is there an option to write the auditing to another file? or maybe to the database itself?

As far as i know, no.
pg_audit exploits the PostgreSQL logging system, so it strongly depends on it.
I hope there will be an option for separate logging too.

Luca

On Thu, Oct 17, 2019 at 12:24 PM M Jane <mskiesewetter@gmail.com> wrote:
>
> Hi Luca,
> Thanks for your answer. That's too bad. I was hoping for a solution.

Of course, it is possible to plug in self-made solutions:
- file fdw to read log files (and import into tables)
- mixture of unix tools to dump AUDIT log entries to a separate log file.

Luca

On Thu, Oct 17, 2019 at 1:40 PM Luca Ferrari <fluca1978@gmail.com> wrote:
> Of course, it is possible to plug in self-made solutions:
> - file fdw to read log files (and import into tables)
> - mixture of unix tools to dump AUDIT log entries to a separate log file.


Seems someone already thought about:
<https://github.com/cmwshang/pgaudit_analyze>.

Luca