Re: Install pgAudit extension

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: Dylan Luong <Dylan(dot)Luong(at)unisa(dot)edu(dot)au>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Install pgAudit extension
Date: 2016-12-06 07:13:53
Message-ID: 1481008433.11165.1.camel@gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Juliano 2016-12-06 08:15:32 Re: Overwrite pg_catalog?
Previous Message Julien Rouhaud 2016-12-06 06:53:44 Re: Migrating data from DB2 zOS to PostgreSQL