Logger - PostgreSQL

PostgreSQL

  1. Edit the PostgreSQL configuration file:
    sudo nano /etc/postgresql/{version}/main/postgresql.conf

Windows system

    C:\Program Files
(x86)\ManageEngine\AppManager12\working\pgsql\data\amdb\postgresql.conf

  1. Add or modify the following settings:

    log_statement = 'all'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d.log'

  2. Restart PostgreSQL:

    sudo systemctl restart postgresql

Restart the service.

services.msc
  1. view logs
C:\Program Files (x86)\ManageEngine\AppManager12\working\pgsql\data\amdb\pgsql_log\
swissql*

login

sudo -u postgres psql postgres