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++ build 1914, 64-bit (not by me).

Regards Niels

PS: Enjoyed your PostgreSQL security talk in Brussels recently.

-----Oprindelig meddelelse-----
Fra: Joe Conway <mail(at)joeconway(dot)com>
Sendt: 13. februar 2019 15:18
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 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.

Joe

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