Re: Implementing pgaudit extension on Microsoft Windows

2019-02-20 Thread Joe Conway
On 2/20/19 5:58 AM, Niels Jespersen wrote: > I did not submit an issue. Instead, I read your input on another > existing issue. In that, you recommended to place pgaudit source in > contrib in a PostgreSQL source tree and build the whole thing. I was hoping you would see that -- it looked pretty m

RE: Implementing pgaudit extension on Microsoft Windows

2019-02-20 Thread Niels Jespersen
om Lane' Cc: 'Pavel Stehule' ; 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 understa

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

2019-02-14 Thread Niels Jespersen
Will do. -Oprindelig meddelelse- Fra: Joe Conway Sendt: 14. februar 2019 00:34 Til: Niels Jespersen ; 'Tom Lane' Cc: 'Pavel Stehule' ; pgsql-general@lists.postgresql.org Emne: Re: SV: SV: Implementing pgaudit extension on Microsoft Windows On 2/13/19 9:17 AM, Jo

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

2019-02-14 Thread Niels Jespersen
ra: Joe Conway Sendt: 13. februar 2019 15:18 Til: Niels Jespersen ; 'Tom Lane' Cc: 'Pavel Stehule' ; 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 so

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

2019-02-13 Thread Joe Conway
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 >> t

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

2019-02-13 Thread Joe Conway
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 pgau

SV: SV: Implementing pgaudit extension on Microsoft Windows

2019-02-13 Thread Niels Jespersen
15:14 Til: Niels Jespersen Cc: 'Pavel Stehule' ; pgsql-general@lists.postgresql.org Emne: Re: SV: Implementing pgaudit extension on Microsoft Windows Niels Jespersen writes: > Same result from > pgaudit.log = 'all' > in postgresql.conf and after both select pg_rel

Re: SV: Implementing pgaudit extension on Microsoft Windows

2019-02-12 Thread Tom Lane
Niels Jespersen 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 ther

Re: Implementing pgaudit extension on Microsoft Windows

2019-02-12 Thread Pavel Stehule
. > It is strange - can you try same setup on linux? > > Regards Niels > > > > > > > > > > > > *Fra:* Pavel Stehule > *Sendt:* 12. februar 2019 09:01 > *Til:* Niels Jespersen > *Cc:* Tom Lane ; pgsql-general@lists.postgresql.org > *Emne:* R

SV: Implementing pgaudit extension on Microsoft Windows

2019-02-12 Thread Niels Jespersen
ql-general@lists.postgresql.org Emne: Re: Implementing pgaudit extension on Microsoft Windows út 12. 2. 2019 v 8:59 odesílatel Pavel Stehule mailto:pavel.steh...@gmail.com>> napsal: út 12. 2. 2019 v 8:57 odesílatel Niels Jespersen mailto:n...@dst.dk>> napsal: Thanks Tom alter system set pgaudit

Re: Implementing pgaudit extension on Microsoft Windows

2019-02-12 Thread Pavel Stehule
ing. >> > > and it doesn't work too if you use postgresql.conf? > don't forget reload select pg_reload_conf(); > Pavel > > >> Regards Niels >> >> >> -Oprindelig meddelelse- >> Fra: Tom Lane >> Sendt: 11. februar

Re: Implementing pgaudit extension on Microsoft Windows

2019-02-12 Thread Pavel Stehule
dt: 11. februar 2019 15:44 > Til: Niels Jespersen > Cc: 'pgsql-general@lists.postgresql.org' < > pgsql-general@lists.postgresql.org> > Emne: Re: Implementing pgaudit extension on Microsoft Windows > > Niels Jespersen writes: > > Copied pgaudit.dll to C:\Pro

SV: Implementing pgaudit extension on Microsoft Windows

2019-02-11 Thread Niels Jespersen
g meddelelse- Fra: Tom Lane Sendt: 11. februar 2019 15:44 Til: Niels Jespersen Cc: 'pgsql-general@lists.postgresql.org' Emne: Re: Implementing pgaudit extension on Microsoft Windows Niels Jespersen writes: > Copied pgaudit.dll to C:\Program Files\PostgreSQL\11\lib Copied &g

Re: Implementing pgaudit extension on Microsoft Windows

2019-02-11 Thread Pavel Stehule
po 11. 2. 2019 v 15:37 odesílatel Pavel Stehule napsal: > > > po 11. 2. 2019 v 14:23 odesílatel Niels Jespersen napsal: > >> Hello all >> >> >> >> Recent Oracle convert here. >> >> >> >> Running PostgreSQL 11 on Windows (10 and 2016). >> >> >> >> Please advise, if I should direct this to another

Re: Implementing pgaudit extension on Microsoft Windows

2019-02-11 Thread Tom Lane
Niels Jespersen writes: > Copied pgaudit.dll to C:\Program Files\PostgreSQL\11\lib > Copied pgaudit.control and pgaudit--1.3.sql to C:\Program > Files\PostgreSQL\11\share\extension > Set shared_preload_libraries = 'pgaudit' > Restart PostgreSQL > Run "CREATE EXTENSION pgaudit;" > alter system se

Re: Implementing pgaudit extension on Microsoft Windows

2019-02-11 Thread Pavel Stehule
po 11. 2. 2019 v 14:23 odesílatel Niels Jespersen napsal: > Hello all > > > > Recent Oracle convert here. > > > > Running PostgreSQL 11 on Windows (10 and 2016). > > > > Please advise, if I should direct this to another mailinglist or forum. > > > > I want to implement detailed object auditing on

Implementing pgaudit extension on Microsoft Windows

2019-02-11 Thread Niels Jespersen
Hello all Recent Oracle convert here. Running PostgreSQL 11 on Windows (10 and 2016). Please advise, if I should direct this to another mailinglist or forum. I want to implement detailed object auditing on PostgreSQL. This is what PGAudit extension does. However most advice on this is directed