Creating log files

After taking a deep look at the system views provided by PostgreSQL, it is time to configure logging. Fortunately, PostgreSQL provides easy means to work with log files and helps people to set up a good configuration easily. Collecting log is important because it can point to errors and potential database problems.

The postgresql.conf file has all the parameters you need to provide you with all the parameters.

Configuring postgresql.conf file

In this section, we will go through some of the most important entries in the postgresql.conf file to configure logging and see how logging can be used in the most beneficial way.

Before we get started, I want to say a few words about logging in PostgreSQL in general. On Unix systems, PostgreSQL will send...