Logger level interference

[yan-hic]

I have enabled trace logging through the URL but the log file only shows connection entries:

FINE: Connecting with URL: jdbc:postgresql://sbxdb:5432/sbx?loggerLevel=TRACE&loggerFile=pgjdbc.log
Sep 14, 2019 12:39:31 PM org.postgresql.Driver connect
FINE: Connecting with URL: jdbc:postgresql://sbxdb:5432/sbx?loggerLevel=TRACE&loggerFile=pgjdbc.log
Sep 14, 2019 12:39:31 PM org.postgresql.Driver connect
FINE: Connecting with URL: jdbc:postgresql://sbxdb:5432/sbx?loggerLevel=TRACE&loggerFile=pgjdbc.log

I had hoped to see what metadata calls (+ args) a third-party app was doing.
pgDatabaseMetaData unfortunately does not log at all but I had expected some more logging from other modules to help debugging.

Could it be that the log level is shared and got reset by the app ? That shouldn't be - the level on the URL should apply across the board within pgjdbc.

Driver Version?
42.2.6

Java Version?
11.0.4

[davecramer]

unlikely it was reset by the app. Much easier to trace in the server logs tho

[yan-hic]

the server shows the SQL only. Only pgdjbc can log what exactly was returned to the client i.e. resultset from the meta methods (columns, data types and values).

If logging is what it is, please consider a feature request to extend logging to pgDatabaseMetaData.