Re: Why log_statement may not work for a particular database?

On Fri, Jun 23, 2023 at 3:38 AM Андрей Платонов <poluandrey(at)gmail(dot)com>
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
> journald),

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.

Cheers,

Jeff