From: | Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au> |
---|---|
To: | Devrim Gündüz <devrim(at)gunduz(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Install pgAudit extension |
Date: | 2016-12-13 01:46:45 |
Message-ID: | f9a8b9cdf8e94c12820305a622338690@ITUPW-EXMBOX2B.UniNet.unisa.edu.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi
Thanks for your reply. I have managed to get pgAudit install and I believe is working as I can see audit logs in my log files.
I like to now install the PostgreSQL Audit Log Analyzer. Is there a similar rpm for the PostgreSQL Audit Log Analyser?
Regards
Dylan
-----Original Message-----
From: Devrim Gündüz [mailto:devrim(at)gunduz(dot)org]
Sent: Tuesday, 6 December 2016 5:44 PM
To: Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Install pgAudit extension
Hi,
On Tue, 2016-12-06 at 05:44 +0000, Dylan Luong wrote:
> I need some advice on installing the pgAudit extension as I am new to
> PostgreSQL extenstions.
Looks like you installed PostgreSQL via community RPMS, so:
https://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/pgaudit_95-1.0.4-1.rhel6.x8
6_64.rpm
it means,
yum install pgaudit_95
will do the trick for installing. Then you can create the extension with:
CREATE EXTENSION pgaudit;
You will need to add some lines to postgresql.conf. Sample ones are here:
https://github.com/devrimgunduz/pgextensionconfig/blob/master/9.5/pgaudit.conf
-HTH
Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR
From | Date | Subject | |
---|---|---|---|
Next Message | Mikhail | 2016-12-13 09:57:14 | pg_upgrade 9.0 to 9.6 |
Previous Message | Julien Rouhaud | 2016-12-12 18:31:43 | Re: ora2pg - Java Message Service (JMS) Type |