How do I change the log level of queries

[garma83]

I want to hide logged queries on the Info level. It is mentioned here but I don't know how to get it to work with PostGres
#1371

[holubond]

@erikpols

// First, you need to create PgConnectOptions
let mut options = PgConnectOptions::new()
    .host("localhost")
    .port("5432")
    .username("myuser")
    .password("somesecretpassword")
    .database("mydb");

// Now it's possible to change the log level of log statements...
options.log_statements(LevelFilter::Trace);
// Or disable it entirely
options.disable_statement_logging();

(the last statement is a bit weird, but for some odd reason options.log_statements() returns &mut Self)

Now it is possible to connect either using the pool...

let pool = Pool::<Postgres>::connect_with(options)
        .await
        .expect("Failed to create db pool");

... or using a single connection

let conn = options.connect()
    .await
    .expect("Failed to create db connection");

[IdemenB]

Is there any such feature to modify logging detail with (Pg)PoolOptions?

[berkeatalay1]

As it is given in this discussion #1964 you can use .connect_with(PgConnectOptions) to change logging level.

let mut pool_connection_options = PgConnectOptions::new()
pool_connection_options.log_statements(LevelFilter::Debug);
let pool = PgPoolOptions::new()
  .connect_with(pool_connection_options)
  .await
  .unwrap();