ossc-db / pgaudit

PostgreSQL Audit Extension
Other
2 stars 4 forks source link

(refactored branch) There is a problem with the explanation of Session Audit Logging / Configuration of Readme.md. #38

Closed harada-toshi closed 7 years ago

harada-toshi commented 7 years ago

There are several problems in the description of Session Audit Logging / Configuration section in README.md of refactored branch.

In accordance with the implementation, it requires a modification of README.md.

harada-toshi commented 7 years ago

I am considering the following amendments.

The session audit log is output in a fixed format (comma separator) defined for each class. The contents of the output format are shown below.

Column number Contents
1 Session audit log header. Fixed character AUDIT: SESSION is set.
2 Statement ID
3 Substatement ID
4 Class
5 Timestamp
6 Database name
7 Session user name
8 Remote host
9 Application name
10 Virtual transaction ID
11 Backend process ID
12 SQLSTATE
13 Message
14 Command tag
15 Object type
16 Object name
17 SQL
18 Parameter
harada-toshi commented 7 years ago

I thought column number 11 was process ID, In the current state of implementation might be another information is stored.

harada-toshi commented 7 years ago

Conclusion at today's offline meeting

We decided the order of audit log output as follows.

Column number Contents
1 Session audit log header. Fixed character AUDIT: SESSION is set.
2 Class
3 Timestamp
4 Remote host
5 Backend process ID
6 Application name
7 Session user name
8 Database name
9 Virtual transaction ID
10 Statement ID
11 Substatement ID
12 Command tag
13 SQLSTATE
14 Object type
15 Object name
16 Message
17 SQL
18 Parameter
harada-toshi commented 7 years ago

We confirmed that the output sequence order was modified. This Issue closes.