We have upgraded two servers by installing postgresql(pgpd) 12. Both servers are running Debian Stable.
On the problem server we have:
pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
11 main 5432 online postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
12 main 5434 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log
But nothing gets written to the logfiles. In stead the logs appear on the console when the user postgresql is connecting to the database.
On the other server:
$ pg_lsclusters
Ver Cluster Port Status Owner Data directory Log file
11 main 5433 down postgres /var/lib/postgresql/11/main /var/log/postgresql/postgresql-11-main.log
12 main 5432 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log
The logging works as expected.
The postgresql.conf for version 12 is identical on both servers - the default installed by Debian.
This is with logging_collector off.
When switching logging_collector on on the problem server, it logs to /var/lib/postgresql/11/main/log/.
Our preference would be to have the logs on both servers in /var/log/postgresql.
Where do we look for the cause of this behaviour? On both servers the configuration for rsyslog seems to be identical.
Regards.
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)