Joe, and others
I did not submit an issue. Instead, I read your input on another existing issue. In that, you recommended to place
pgauditsource 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
worksfine. 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
onlya 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,
ifthere is interest.
Regards Niels
-----Oprindelig meddelelse-----
Fra: Joe Conway <mail@joeconway.com>
Sendt: 14. februar 2019 00:34
Til: Niels Jespersen <NJN@dst.dk>; 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: 'Pavel Stehule' <pavel.stehule@gmail.com>; pgsql-general@lists.postgresql.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
moredetails 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