Re: Question about pgaudit and the logfile

Luca Ferrari <[email protected]> Wed, 16 Oct 2019 09:19:30 +0200
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAKoxK+4MnOgzUsVs+p6DCgUMxYgq9eiZJXpAbPLsV4+VOC49_A@mail.gmail.com>
On Tue, Oct 15, 2019 at 11:25 AM M Jane <[email protected]> wrote:
> I am looking into the pgaudit extension and I have read in the readme file that the audit logging is being written to the alertlog 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