RE: Implementing pgaudit extension on Microsoft Windows

From: Niels Jespersen <NJN(at)dst(dot)dk>
To: 'Joe Conway' <mail(at)joeconway(dot)com>, 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 'Pavel Stehule' <pavel(dot)stehule(at)gmail(dot)com>, "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-20 10:58:51
Message-ID: 3967181ED595B445B1E39718204FD4BD0107BCCF9A@SRVEXC5.dst.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe, and others

I did not submit an issue. Instead, I read your input on another existing issue. In that, you recommended to place pgaudit source in contrib in a PostgreSQL source tree and build the whole thing.

I did just that this morning using 11.2 (my first compile of PostgreSQL (which succeeeded)). The resulting pgaudit.dll works fine. So far at least, I haven't tried all features, but pgaudit.log = 'all' generates lots of log.

I also pulled the commands to build pgaudit from the build log and can now compile pgaudit to a working dll against only a binary installation.

All is good.

Perhaps my experiences could be added to the project. I am willing to write a short markdown document describing this, if there is interest.

Regards Niels

-----Oprindelig meddelelse-----
Fra: Joe Conway <mail(at)joeconway(dot)com>
Sendt: 14. februar 2019 00:34
Til: Niels Jespersen <NJN(at)dst(dot)dk>; 'Tom Lane' <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: 'Pavel Stehule' <pavel(dot)stehule(at)gmail(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org
Emne: Re: SV: SV: Implementing pgaudit extension on Microsoft Windows

On 2/13/19 9:17 AM, Joe Conway wrote:
> On 2/13/19 3:32 AM, Niels Jespersen wrote:
>> Dive into the source for pgaudit and try to understand how it works,
>> perhaps getting a small example extension working along the way.
>> Perhaps contacting the authors of pgaudit to have them confirm that
>> there exists working implementations of pgaudit on Windows (and if
>> so if they are on PostgreSQL 11).
>
> pgaudit definitely *should* work on Windows. If you can post your
> other log related conf settings I will fire up a Windows VM and try to
> duplicate the issue.

I just compiled pgaudit on a Win10 VM and loaded it into a Postgres 11
Win64 build downloaded from the PGDG community download. Works perfectly for me. Will definitely need to understand more details about your installation. Probably not appropriate to do that on this list, so please submit an issue on github.com/pgaudit/pgaudit

Thanks,

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2019-02-20 11:58:43 Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes
Previous Message Mike Yeap 2019-02-20 10:12:59 LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes