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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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.



[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux