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:dev...@gunduz.org] Sent: Tuesday, 6 December 2016 5:44 PM To: Dylan Luong <dylan.lu...@unisa.edu.au>; pgsql-general@postgresql.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
