Chapter 4. Managing Logfiles

In this chapter, we will be covering the management of the PostgreSQL logfile. You will be guided through the most essential configuration switches. If there is anything related to administration—this is it. You will learn about various log levels and, hopefully, gain valuable insights.

By the end of this chapter, log management will be an easy task for you.

This chapter covers the following topics:

  • Understanding the PostgreSQL log architecture
  • Configuring log output amounts
  • Making log creation more fine grained

Understanding the PostgreSQL log architecture

If you have compiled PostgreSQL from source, you will see that by default, all the logging generated simply goes to standard error (stderr). Sending log output to stderr ...

Get PostgreSQL Administration Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.