SV: SV: Implementing pgaudit extension on Microsoft Windows

Hi Tom (and others)

Thank you for input. I think my next steps will be approcching the problem from differenct angles:

Implement on Linux as Proof of Concept.
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).

I will report how this turns out.

Regards Niels

-----Oprindelig meddelelse-----
Fra: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sendt: 12. februar 2019 15:14
Til: Niels Jespersen <NJN(at)dst(dot)dk>
Cc: 'Pavel Stehule' <pavel(dot)stehule(at)gmail(dot)com>; pgsql-general(at)lists(dot)postgresql(dot)org
Emne: Re: SV: Implementing pgaudit extension on Microsoft Windows

Niels Jespersen <NJN(at)dst(dot)dk> writes:
> Same result from
> pgaudit.log = 'all'
> in postgresql.conf and after both select pg_reload_conf(); and after service restart.
> No entries in the log from audit.

Hm. I don't know much about pgaudit, but just from scanning its documentation, it doesn't seem like there's anything else that has to be set.

I wonder whether pgaudit actually works on Windows? It might have some weird dependency on children being spawned with fork not exec, for instance. You probably ought to contact the authors and ask.

regards, tom lane