How to enable access logging in PostgreSQL 13 servers
search cancel

How to enable access logging in PostgreSQL 13 servers

book

Article ID: 396977

calendar_today

Updated On: 05-11-2025

Products

VMware Aria Suite

Issue/Introduction

This article explains how to enable logging of database user logins and logouts in PostgreSQL 13 servers.

 

Environment

Aria Automation Config 8.x

Resolution

To enable logging of database user logins and logouts, set the following parameters to ON in the configuration file located at "/srv/psql/13/data/postgres.conf".

log_connections = on
log_disconnections = on

Once the parameter is set to ON, restart the postgres service using the below command.

systemctl status postgresql-13.service