From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Niels Jespersen <NJN(at)dst(dot)dk> |
Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Implementing pgaudit extension on Microsoft Windows |
Date: | 2019-02-11 14:37:05 |
Message-ID: | CAFj8pRB+DoTxk83R0TmiazRiyRsCda4RgDXGGb7CDQ1rkymXjg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
po 11. 2. 2019 v 14:23 odesílatel Niels Jespersen <NJN(at)dst(dot)dk> napsal:
> Hello all
>
>
>
> Recent Oracle convert here.
>
>
>
> Running PostgreSQL 11 on Windows (10 and 2016).
>
>
>
> Please advise, if I should direct this to another mailinglist or forum.
>
>
>
> I want to implement detailed object auditing on PostgreSQL. This is what
> PGAudit extension does. However most advice on this is directed at Linux
> and friends, which is fair enough. From Googleing around, it seems it
> should be possible to compile on Windows, though.
>
>
>
> And it is. I have compiled pgaudit.dll from the source out of pgaudit
> version 1.3.
>
>
>
> And this:
>
>
>
> Copied pgaudit.dll to C:\Program Files\PostgreSQL\11\lib
>
> Copied pgaudit.control and pgaudit--1.3.sql to C:\Program
> Files\PostgreSQL\11\share\extension
>
> Set shared_preload_libraries = 'pgaudit'
>
> Restart PostgreSQL
>
> Run “CREATE EXTENSION pgaudit;”
>
> alter system set pgaudit.log = 'all';
>
> select pg_reload_conf();
>
>
>
> Nothing enters the log-file from pgaudit. Creating tables (relations,
> sorry). Selecting from tables, nothing in the log.
>
>
>
> I can see that alter system set pgaudit.logx = 'all'; complains about
> “unrecognized configuration parameter”, so something is known about
> pgaudit.
>
>
>
> I can see that postgres.exe has locked pgaudit.dll, so postgreSQL knows it
> is there, but nothing in the log-file.
>
>
>
> I need some advice regarding the next steps in my troubleshooting.
>
probably you should to use
alter system set "pgaudit.log" = 'all';
Regards
Pavel
>
> Regards
>
>
>
> Niels Jespersen
>
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-02-11 14:43:32 | Re: Implementing pgaudit extension on Microsoft Windows |
Previous Message | Daniel Fink (PDF) | 2019-02-11 14:32:12 | RE: bdr replication breaks down |