RE: Implementing pgaudit extension on Microsoft Windows - Mailing list pgsql-general

From Niels Jespersen
Subject RE: Implementing pgaudit extension on Microsoft Windows
Date
Msg-id 3967181ED595B445B1E39718204FD4BD0107BCCF9A@SRVEXC5.dst.local
Whole thread Raw
Responses Re: Implementing pgaudit extension on Microsoft Windows  (Joe Conway <mail@joeconway.com>)
List 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
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


pgsql-general by date:

Previous
From: Mike Yeap
Date:
Subject: LDAP authenticated session terminated by signal 11: Segmentationfault, PostgresSQL server terminates other active server processes
Next
From: Laurenz Albe
Date:
Subject: Re: LDAP authenticated session terminated by signal 11:Segmentation fault, PostgresSQL server terminates other active serverprocesses