Postgres Pro
Downloads
Home   >   mailing lists

Thread: Default logging (log_statement) versus pgaudit

Default logging (log_statement) versus pgaudit

From
"Heckler, Kim M"
Date:

Is the pgaudit.log setting, for pgaudit, independent of the default logging setting (log_statement)?   Can log_statement be ‘none’ while the pgaudit.log be ‘all’?

 

Nationwide is on your side.

Kim M. Heckler

Consultant, Infrastructure Eng

Proud Nationwide Member

Run Distributed Database Storage

W 614-249-3014

C 740-816-0908

kim.heckler@nationwide.com

FORTUNE® and Time Inc. are not affiliated with, and do not endorse the products or services of, Nationwide Mutual Insurance Company.

 

 

 

 

Attachment

Re: Default logging (log_statement) versus pgaudit

From
Simon Riggs
Date:
On Thu, 22 Aug 2019 at 17:29, Heckler, Kim M <kim.heckler@nationwide.com> wrote:

Is the pgaudit.log setting, for pgaudit, independent of the default logging setting (log_statement)?   Can log_statement be ‘none’ while the pgaudit.log be ‘all’?


Independent, yes, but pgaudit is designed to be used in place of log_statement = 'all'

--
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Solutions for the Enterprise
Attachment