Verify your knowledge
- What is the difference between logging and auditing?
Logging is a way to track certain activities that happen within the cluster, without any particular regard to the “target” of such an activity. On the other hand, auditing is a way to log and track specific activities that happen on specific targets. For example, logging can track “every slow query” without any regard to the table the query is run against, while auditing can track “every modification to table xyz.” See the Implementing auditing section for more details.
- What is pgBadger?
pgBadger is an external command that can inspect the PostgreSQL textual logs and build a dashboard with the cluster activity. See the Extracting information from logs – pgBadger section for more details.
- How can the database administrator decide where to send PostgreSQL logs?
PostgreSQL provides a set of logging configuration...
