How to disable logging/tracing

[emaborsa]

I am working with with pgxpool v5, this is how I create the pool:

const timeout = time.Second * 90

func initDatabasePool(connString string) (*pgxpool.Pool, error) {
	config, err := pgxpool.ParseConfig(connString)
	if err != nil {
		return nil, err
	}

	config.MaxConnLifetime = timeout 
	config.MaxConnIdleTime = timeout 

	return pgxpool.NewWithConfig(context.Background(), config)
}

The database prints everything to console. How can I prevent it from that? I tryied to add config.ConnConfig.Tracer = nil, but doesn't help.

[felix-roehrich]

pgx doesn't log anything to the console with default settings. Please check your own code for any statements that print and, if you can't find anything, please create a repo with a minimal example that reproduces the problem.

[emaborsa]

I checked my code, did not find and print statement. Let's take this snippet from my code:

rows, err := r.pool.Query(ctx, query, args...)

If I set a break point at this line, the console is clear. Once i hit F10, the query is printed to console, this means it must be a setting, right?

[felix-roehrich]

As I said before, pgx does not log anything if you use default settings. My best guess is that you have some other logging utility configured which triggers this.
The best way to check if this is really a problem with pgx is to create a clean project with pgx only and try to see if the issue persists. If it does, then please post the example.

[emaborsa]

OK, i got it, but could you tell me which setting would trigger this logging?

[jackc]

Presumably, your connection https://pkg.go.dev/github.com/jackc/pgx/v5#ConnConfig has a Tracer set.