PostgreSQL enable logging

Опубликовано: 25 Май 2025
на канале: TECHWIKI
377
0

LinkedIn -   / ruslan-potomka  

In today's video, we will show you how to enable logging in a PostgreSQL database.
A background process is responsible for logging in Postgresql, which collects various information about the database robot and writes this information somewhere.
The information can be completely different, various errors, attempts to authorize clients, etc.
After installing the DBMS and creating the database itself, the logging process in the database is disabled by default.

0:00 Start
0:11 Switching to the user postgres
0:23 Checking the database status
0:29 Connecting to the database via the console psql
0:32 Checking the current logging status
1:25 Enable logging in the configuration file
4:16 Restarting the database
4:27 Recheck logging status
5:00 The end

#postgresql #dbms #postgres #pgstatus #db #database