pgAudit 1.0.7 commit log

Stamp 1.0.7.

commit   : 847d3bdbaba356a46d1408b2fe9105dd73d52cc7    
  
author   : David Steele <[email protected]>    
date     : Thu, 23 May 2019 13:25:52 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 23 May 2019 13:25:52 -0400    

Click here for diff

M Makefile
A pgaudit–1.0.6–1.0.7.sql
R094 pgaudit–1.0.6.sql pgaudit–1.0.7.sql
M pgaudit.control

Update Vagrantfile with new box version and PostgreSQL repository.

commit   : 4a25265974287f45e987aa4e15bba17de651bef2    
  
author   : David Steele <[email protected]>    
date     : Thu, 23 May 2019 12:36:16 -0400    
  
committer: David Steele <[email protected]>    
date     : Thu, 23 May 2019 12:36:16 -0400    

Click here for diff

M test/Vagrantfile

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

commit   : 833a368b6f8ffb0f090645d8921111a639e10d5c    
  
author   : Mike Palmiotto <[email protected]>    
date     : Thu, 24 Jan 2019 10:19:21 +0200    
  
committer: David Steele <[email protected]>    
date     : Thu, 24 Jan 2019 10:19:21 +0200    

Click here for diff

M README.md

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

commit   : d4c8c83f19ab83f26f7ddbcb7a83a9e724d74388    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 22:19:10 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 22:19:10 +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   : 0bbf1a3394bad2694cb793a46d05e223fbfda2ac    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 19:00:13 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 19:00:13 +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   : 733d22b80d3897b7f25e56c1a88fd5eed11e3b7c    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:46:38 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:46:38 +0200    

Click here for diff

M README.md

Add ALL to the list of logging classes.

commit   : 0d9496a6273a5f9f465839aa451f64d0ed80e064    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:31:32 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:31:32 +0200    

Click here for diff

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

M README.md

Fix typo in documentation.

commit   : ba73feb983bf63fd9e3afb5e3228d4e01622d363    
  
author   : David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:13:49 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:13:49 +0200    

Click here for diff

M README.md

Fix DO example syntax.

commit   : 6f95ba630ce83ccba26ee897b5dc86c50b7681a8    
  
author   : Christoph Berg <[email protected]>    
date     : Wed, 23 Jan 2019 18:12:09 +0200    
  
committer: David Steele <[email protected]>    
date     : Wed, 23 Jan 2019 18:12:09 +0200    

Click here for diff

M README.md

Deep copy queryDesc->params into the audit stack.

commit   : 10c307d4c2bd03a3e389be3c8bc01eb4d782beef    
  
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   : dcb56f0baeebe9792bb2e1962c501079151fe02c    
  
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

Update build instructions to use PGXS.

commit   : 1a1fa58c9bf2e049a6ad03e0dd7fa3f86a328c56    
  
author   : David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 12:47:29 +0100    
  
committer: David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 12:47:29 +0100    

Click here for diff

M README.md

Add version information for PostgreSQL 11.

commit   : 6cba8f1597613633d15c36dc4dcaf6811efed60d    
  
author   : David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 10:47:46 +0100    
  
committer: David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 10:47:46 +0100    

Click here for diff

M README.md

Add step to checkout correct pgaudit branch during build.

commit   : 7ff34f33c3918efb4b296d2208e94bd1def57f45    
  
author   : David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 10:45:33 +0100    
  
committer: David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 10:45:33 +0100    

Click here for diff

M README.md

Reinstate log_client documentation accidentally removed in 83a2f4e6.

commit   : 8ce3e3eaedce3ed9db0674fa1935cf14f7fa029a    
  
author   : David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 10:39:47 +0100    
  
committer: David Steele <[email protected]>    
date     : Wed, 3 Oct 2018 10:39:47 +0100    

Click here for diff

M README.md

Update documentation for PostgreSQL 10 release.

commit   : bc5f11f2ee805a301296c72ae4f1e07759063160    
  
author   : David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 12:48:55 -0400    
  
committer: David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 12:48:55 -0400    

Click here for diff

M README.md

Copyright update and minor whitespace fixes.

commit   : 0da93f4c4651669f51dfff2de502fb9e9d9f5f52    
  
author   : David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 12:33:30 -0400    
  
committer: David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 12:33:30 -0400    

Click here for diff

M pgaudit.c

Add missing GUC reset in expect test.

commit   : 154d73a1e5f3e60ff0ecd8d985cc56bb78d36f0f    
  
author   : David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 12:27:47 -0400    
  
committer: David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 12:27:47 -0400    

Click here for diff

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

Make build more robust in Vagrantfile.

commit   : 34686983b7e3745968b6020fc8915faa30561561    
  
author   : David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 11:46:58 -0400    
  
committer: David Steele <[email protected]>    
date     : Tue, 3 Oct 2017 11:46:58 -0400    

Click here for diff

M test/Vagrantfile