SV: SV: SV: Implementing pgaudit extension on Microsoft Windows

Hi Joe

That is great. 

Log related settings are here:

log_destination = 'stderr'
logging_collector = on
log_file_mode = 0640
log_timezone = 'Europe/Brussels'
shared_preload_libraries = 'pgaudit'
pgaudit.log = 'all'

show shared_preload_libraries; 

and 

show pgaudit.log; 

confirms. 

Pgaudit is 1.3.0, compiled with Vsiual Studio Professional 2017. PostgreSQL is PostgreSQL 11.0, compiled by Visual C++
build1914, 64-bit (not by me). 
 

Regards Niels

PS: Enjoyed your PostgreSQL security talk in Brussels recently. 

-----Oprindelig meddelelse-----
Fra: Joe Conway <mail@joeconway.com> 
Sendt: 13. februar 2019 15:18
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 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
WindowsVM and try to duplicate the issue.
 

Joe

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