pgAudit 1.4.0 commit log

by Yogesh Sharma
pgAudit
commit log

Update version, documentation, and tests for PostgreSQL 12.

commit   : e1b2d890a393b8d70a10e4fb153cdba5a8fdb8b8    
  
author   : David Steele <[email protected]>    
date     : Wed, 7 Aug 2019 16:57:42 -0400    
  
committer: David Steele <[email protected]>    
date     : Wed, 7 Aug 2019 16:57:42 -0400

Click here for diff

M Makefile
M README.md
R094 pgaudit–1.3.sql pgaudit–1.4.sql
M pgaudit.control
M test/Vagrantfile

Update master to PostgreSQL 12.

commit   : 8c76e69de9ce791c5bfb4cc641be35e77cfb77fc    
  
author   : Honza Horak <[email protected]>    
date     : Wed, 7 Aug 2019 22:03:04 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 7 Aug 2019 22:03:04 +0200

Click here for diff

M pgaudit.c

commit   : dff82bc137d11f50642152ea264d359c99dce159    
  
author   : David Steele <[email protected]>    
date     : Thu, 23 May 2019 14:19:40 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 23 May 2019 14:19:40 -0400

Click here for diff

M pgaudit.c

Update Vagrantfile with new box version and PostgreSQL repository.

commit   : 778d9efb3558da6e5b71f0bff8d8fbde4e550cb2    
  
author   : David Steele <[email protected]>    
date     : Thu, 23 May 2019 12:12:38 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 23 May 2019 12:12:38 -0400

Click here for diff

M test/Vagrantfile

Add new logging class MISC_SET.

commit   : b1d81db598690a6edcd923909203bb54cf06d6dc    
  
author   : Mike Palmiotto <[email protected]>    
date     : Thu, 24 Jan 2019 18:10:34 +0200    
  
committer: David Steele <[email protected]>    
date     : Thu, 24 Jan 2019 18:10:34 +0200

Click here for diff

This logging class includes only SET commands and is more targeted than using MISC for the same purpose.  
  
There is no expected behavioral change for current configurations with this new logging class.  The MISC class will continue to log SET commands.  
  
SET commands will be logged with the MISC class even if only MISC_SET was specified to avoid log format changes.

M README.md
M expected/pgaudit.out
M pgaudit.c
M sql/pgaudit.sql

Add SET to documented list of commands in the MISC class.

commit   : 4dab520da72543b100a0ebb6e4ca19ac20f0698c    
  
author   : Mike Palmiotto <[email protected]>    
date     : Thu, 24 Jan 2019 10:16:52 +0200    
  
committer: David Steele <[email protected]>    
date     : Thu, 24 Jan 2019 10:16:52 +0200

Click here for diff

M README.md

Document that <none> or <not logged> may be logged in audit entries.

commit   : 142f4e9460a5c20669cfe7a8c1a99ab1aa611c7b    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 22:16:31 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 22:16:31 +0200

Click here for diff

This was likely missed after a behavioral change early on in development.  
  
Update examples as appropriate.

M README.md

Add [%p] to suggested log_line_prefix.

commit   : 94cad8c8cb64f2773904082469407c361d6322ca    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:57:44 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:57:44 +0200

Click here for diff

The documentation suggests that the process id is useful for correlating log entries so it makes sense to include it in the suggested log prefix example.  
  
Note that the CSV format is generally more useful in this case and it already includes the process id.

M README.md

Remove extraneous escapes in log prefix example.

commit   : 9fd8f04b22bfca4d4a1dd40564917238817f9651    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:42:55 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:42:55 +0200

Click here for diff

M README.md

Add ALL to the list of logging classes.

commit   : 330c2177c8a9dd622bbfdd8a301e0f329f3b9dc6    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:25:14 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:25:14 +0200

Click here for diff

This class was referenced in other parts of the documentation but never explicitly listed.

M README.md

Fix DO example syntax.

commit   : 1f65fe9c98c5d33effe218628ee7cc8a2950e06b    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:07:36 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:07:36 +0200

Click here for diff

M README.md

Deep copy queryDesc->params into the audit stack.

commit   : b2040b6e6c74718afd41b4ba46243fc31a286cfa    
  
author   : Joe Conway <[email protected]>    
date     : Wed, 23 Jan 2019 16:24:27 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 16:24:27 +0200

Click here for diff

Apparently queryDesc->params does not live in a sufficiently long-lived memory context for use when needed.  
  
By sheer luck this is only intermittently an actual problem, but in any case deep copy queryDesc->params for use in the audit stack.

M expected/pgaudit.out
M pgaudit.c

Fix typo in shared_preload_libraries comment.

commit   : 79c35e6db8512f858f1403ef2d9fdbf1292878a8    
  
author   : Christoph Berg <[email protected]>    
date     : Tue, 20 Nov 2018 21:57:10 +0100    
  
committer: David Steele <[email protected]>    
date     : Tue, 20 Nov 2018 21:57:10 +0100

Click here for diff

M pgaudit.c