Explanation of the above added parameters in system yaml file:

ARTIFACTORY: Why Artifactory is unable to connect to DB when DB is configured with the pg bouncer

AuthorFullName__c
Pranav Hegde
articleNumber
000005624
ft:sourceType
Salesforce
FirstPublishedDate
2023-03-19T09:52:00Z
lastModifiedDate
2023-03-19T09:52:00Z
VersionNumber
1
>> Metadata is built-in go language and we use the "pgx" DB driver. In order to disable the prepared statement, we have to send this specific parameter in the system.yaml.
metadata.database.url: go:user='artifactory' password='*******' dbname=artifactory host=localhost port=6432 sslmode=disable statement_cache_mode=describe

>> Additionally, we have also implemented our own caching layer with the Metadata service. In order to disable the inbuilt caching mechanism, we need to add the below parameter in the system.yaml.
metadata.database.disablePreparedStatementCache: true