pgAudit 1.1.2 commit log

Stamp 1.1.2.

commit   : 527fa2114bf9fec12593c71e00ed30f314acaf3a    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 13:15:43 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 13:15:43 -0400    

Click here for diff

M Makefile
A pgaudit–1.1.1–1.1.2.sql
R094 pgaudit–1.1.1.sql pgaudit–1.1.2.sql
M pgaudit.control

Update Vagrantfile with new box version and PostgreSQL repository.

commit   : 5caff1395cf9070e70a1e85a7592d7010e4ff1e2    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 12:34:05 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 23 May 2019 12:34:05 -0400    

Click here for diff

M test/Vagrantfile

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

commit   : afd2317f3294bacc56cd1ebc25c5e746af20dda3    
  
author   : Mike Palmiotto <mike.palmiotto@crunchydata.com>    
date     : Thu, 24 Jan 2019 10:18:49 +0200    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 24 Jan 2019 10:18:49 +0200    

Click here for diff

M README.md

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

commit   : 34d086ecc2fbf36c546aa5eaf5fa0d48ca6ab86f    
  
author   : Christoph Berg <cb@df7cb.de>    
date     : Wed, 23 Jan 2019 22:18:33 +0200    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 23 Jan 2019 22:18:33 +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   : 996510ef89c27474736a00e003f4f1334144087f    
  
author   : Christoph Berg <cb@df7cb.de>    
date     : Wed, 23 Jan 2019 18:59:37 +0200    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 23 Jan 2019 18:59:37 +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   : ff4451ebb43749f9bfd896dd6835f1b883688550    
  
author   : Christoph Berg <cb@df7cb.de>    
date     : Wed, 23 Jan 2019 18:45:52 +0200    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 23 Jan 2019 18:45:52 +0200    

Click here for diff

M README.md

Add ALL to the list of logging classes.

commit   : 7cfe2ea7ca4aa79883810c230ebb7ebc5d88fa9d    
  
author   : Christoph Berg <cb@df7cb.de>    
date     : Wed, 23 Jan 2019 18:31:00 +0200    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 23 Jan 2019 18:31:00 +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   : b2b2da7b6d25e5dd896aa53a83d4ac892d3d1f46    
  
author   : Christoph Berg <cb@df7cb.de>    
date     : Wed, 23 Jan 2019 18:10:11 +0200    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 23 Jan 2019 18:10:11 +0200    

Click here for diff

M README.md

Deep copy queryDesc->params into the audit stack.

commit   : 6868bdc13de3dd50e46890a3e69f54d0960c910b    
  
author   : Joe Conway <mail@joeconway.com>    
date     : Wed, 23 Jan 2019 16:24:27 +0200    
  
committer: David Steele <david@pgmasters.net>    
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   : c2eda0406a4732e04a50d22344b93c4df4cf9e47    
  
author   : Christoph Berg <cb@df7cb.de>    
date     : Tue, 20 Nov 2018 21:57:10 +0100    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 20 Nov 2018 21:57:10 +0100    

Click here for diff

M pgaudit.c

Update build instructions to use PGXS.

commit   : 0c6e6b1025603ee1edc3a1b1ec30a909000768ea    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 12:53:43 +0100    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 12:53:43 +0100    

Click here for diff

M README.md

Add version information for PostgreSQL 11.

commit   : 516b1158ee54f72c0d77c055c4a302e2847910ce    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 10:48:04 +0100    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 10:48:04 +0100    

Click here for diff

M README.md

Add step to checkout correct pgaudit branch during build.

commit   : 595f956529cb1685fb1b404dce4144d0c2641da4    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 10:46:24 +0100    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 10:46:24 +0100    

Click here for diff

M README.md

Reinstate log_client documentation accidentally removed in 83a2f4e6.

commit   : 0b5d9fc53f0e695b7e5e763b339b8bb68ee4474e    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 10:41:06 +0100    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 3 Oct 2018 10:41:06 +0100    

Click here for diff

M README.md

Update documentation for PostgreSQL 10 release.

commit   : 8f1f8ff9885b9eacad031d6c2b456d951f013929    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:49:44 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:49:44 -0400    

Click here for diff

M README.md

commit   : 93d32c6e5c5d8ac7e7d02375aeaf93da48d2bdf8    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:36:28 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:36:28 -0400    

Click here for diff

M pgaudit.c

Add missing GUC reset in expect test.

commit   : 57ce3d471982902756d7d027667f37eff547ce00    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:29:05 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:29:05 -0400    

Click here for diff

M expected/pgaudit.out
M sql/pgaudit.sql

Make build more robust in Vagrantfile.

commit   : fc31de3eac780cdd764b88b73872e3d44d9d1c6d    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:18:41 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 3 Oct 2017 12:18:41 -0400    

Click here for diff

M test/Vagrantfile