On Fri, Jun 23, 2023 at 3:38 AM Андрей Платонов <poluandrey@xxxxxxxxx> wrote:
As I understand settings above should lead to the fact that I should
see statement logging for all databases into `stderr` (in fact into
How does it get from stderr to journald? Maybe the messages for other databases are getting filtered out after PostgreSQL generates them. Maybe you could bypass journald for now while you investigate, just to rule out non-PostgreSQL related possibilities. Or "set client_min_messages TO log" so that your client gets sent copies of log messages directly.
I also checked the settings of the `mydatabase`
mydatabase=# SELECT name, setting FROM pg_settings WHERE name LIKE '%log%';
This only checks the settings of a particular connection. Did you use this same connection to issue statements that should have been logged? Maybe a stupid question, but how do you know anything loggable is happening? Maybe you don't see messages because nobody does stuff in that database which would generate them.