Re: Regarding pgaudit log_directory

From: David Steele <david(at)pgmasters(dot)net>
To: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
Cc: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: Regarding pgaudit log_directory
Date: 2019-03-31 20:47:56
Message-ID: 86ed2239-fdba-21bc-e5dc-3b80b9b962e7@pgmasters.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/31/19 8:01 PM, Durgamahesh Manne wrote:
>
> On Saturday, March 30, 2019, David Steele <david(at)pgmasters(dot)net
> <mailto:david(at)pgmasters(dot)net>> wrote:
>
> On 3/29/19 3:32 PM, Durgamahesh Manne wrote:
>
>    I could not find parameter related to pgaudit log_directory  .
>
> pgAudit does not support logging outside the standard PostgreSQL
> logging facility and there are no plans for such a feature.
>
> The general solution is to use Splunk, ELK, etc. to do manipulation
> of the PostgreSQL logs.
>
> Regards,
> --
> -David
> david(at)pgmasters(dot)net <mailto:david(at)pgmasters(dot)net>
>
> Please let me know open source application interface to monitor of
> pgaudit logs only
> As I have installed pgaudit successfully

For open source ELK is probably your best bet. This may help get you
started:
https://prezi.com/f2dvt6m9tbf9/integrating-postgresql-with-logstash-for-real-time-monitoring/

--
-David
david(at)pgmasters(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2019-03-31 22:14:12 Re: Gigantic load average spikes
Previous Message Durgamahesh Manne 2019-03-31 19:26:32 Regarding pgaudit