Oh okay! I wasn't aware of the pg_settings system view. Thanks for all
the info!
On Thu, Nov 21, 2019 at 1:36 PM Joe Conway wrote:
> On 11/21/19 1:27 PM, Dave Hughes wrote:
> > Thank you so much for all your help! I found out my issue on accident
> > actually. I backed up all my user account
On 11/21/19 1:27 PM, Dave Hughes wrote:
> Thank you so much for all your help! I found out my issue on accident
> actually. I backed up all my user accounts into a SQL scripts and after
> reviewing it, I noticed there were some lines that said:
> ALTER ROLE postgres SET "pgauid.log" to 'Role';
>
Thank you so much for all your help! I found out my issue on accident
actually. I backed up all my user accounts into a SQL scripts and after
reviewing it, I noticed there were some lines that said:
ALTER ROLE postgres SET "pgauid.log" to 'Role';
ALTER ROLE postgres SET "pgaudit.log_level" to 'no
On 11/20/19 5:54 PM, Dave Hughes wrote:
> Thanks for the tips Joe! After fighting with this all day, I realized
> while I was testing this, I was logging into the database as the
> "postgres" user. For some reason those actions were not being logged.
> But once I logged in as another superuser a
Thanks for the tips Joe! After fighting with this all day, I realized
while I was testing this, I was logging into the database as the "postgres"
user. For some reason those actions were not being logged. But once I
logged in as another superuser account I have, I saw all my ddl statements
being
On 11/20/19 8:09 AM, Dave Hughes wrote:
> Hey,
> Thanks for reaching out. It looks like I have that parameter set as
> well. Here is a list of settings I have turned on in postgresql.conf
> since I installed pgAudit:
>
> shared_preload_libraries = 'pgaudit'
> log_destination = 'csvlog'
> logging
Hey,
Thanks for reaching out. It looks like I have that parameter set as well.
Here is a list of settings I have turned on in postgresql.conf since I
installed pgAudit:
shared_preload_libraries = 'pgaudit'
log_destination = 'csvlog'
logging_collector = on
log_directory = '/work/PostgreSQL/10/d
Hello Dave,
What I can see is you missed to include pgAudit extension in
shared_preload_libraries parameter (*shared_preload_libraries='pgaudit'*).
Thanks
Rajni
On Wed, Nov 20, 2019 at 7:39 AM Dave Hughes wrote:
> Hello,
> I'm using PostgreSQL 10.5 on Linux (RHEL). I recently installed pgAudit
Hello,
I'm using PostgreSQL 10.5 on Linux (RHEL). I recently installed pgAudit
and was trying to configure it to capture DLL statements.
1) The first thing I tried was to edit the postgresql.conf file directly.
I didn't see any commented out default entries to edit, so near where I
have the entri
