postgres logs - ghdrako/doc_snipets GitHub Wiki

• https://sematext.com/blog/postgresql-logs/

PostgreSQL logs are text files showing you information related to what is currently happening in your database system. This includes who has access to what component, what errors have occurred, what settings have changed, what queries are in process, and what transactions are being executed.

To enable PostgreSQL to create its own log files, you have to enable the logging_collector parameter. When you do, logs will start going to the default location defined by your OS. Below are the default log directories for a few different operating systems:

• Debian-based system:e /var/log/postgresql/postgresql-x.x.main.log. X.x.
• Red Hat-based system: /var/lib/pgsql/data/pg_log
• Windows: C:\Program Files\PostgreSQL\9.3\data\pg_log

To change the location where the log files are stored when the log collector is enabled, you can use the log_directory parameter to specify a custom directory.

Note that logging can sometimes be a problem in PostgreSQL. The logging collector will not allow any log messages to be lost, so at high load, it can block server processes, resulting in issues. You can use syslog instead, as it can drop some messages and will not block the system. To disable the logging collector, you can configure the option to off:

logging_collector off

Syslog

You need to do this on the syslog daemon via the following configuration:

local0.* /var/log/postgresql