Use the following command to check the database logs. The database logs are kept daily.
[root@kronpam~]#tail -100f /pam/PostgreSQL11/data/log/postgresql-2024-07-23.log