Related to the question above, is there anyway to ...
# ory-selfhosting
h
Related to the question above, is there anyway to get
binary_parameters=yes
working with the Postgres connection. My understanding is that it should work as a DSN parameter with
lib/pq
. But I get an error if I include this parameter stating it is an unsupported startup parameter. I’m not sure which library produces this error. We need this parameter because we use PG Bouncer.
Or is PGX used? This would be the typical code to set this up, but I’m not sure how to make this happen in Kratos.
Copy code
config.ConnConfig.StatementCacheCapacity = 0                             // disable statement cache
	config.ConnConfig.DefaultQueryExecMode = pgx.QueryExecModeSimpleProtocol // disable statement cache
I think I just figured it out:
Copy code
&prefer_simple_protocol=true&statement_cache_capacity=0