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