Postgresql is set to sslmode=require -> connection failed.

[rafeeque1]

Describe the bug
void DbClientManager::addDbClient(const DbConfig &config)
{
if (std::holds_alternative(config))
{
#if USE_POSTGRESQL
auto &cfg = std::get(config);
auto connStr = buildConnStr(cfg.host,
cfg.port,
cfg.databaseName,
cfg.username,
cfg.password,
cfg.characterSet);

why we are using only host , port , databaseName, username etc only?
what if my postgresql set sslmode=require , then how to include sslmode etc into connection string

ConnectionString = "dbname=defaultdb user=avnadmin password={PASSWORD} host={HOST} port=22389 sslmode=require"
if sslmode=require on postgresql

To Reproduce
Steps to reproduce the behavior:

1. Go to aiven cloud (aiven.io)

2. create a postgresql

3. try to connect with drogon

4. and see the error -> ERROR !!!Pg connection failed: FATAL: no pg_hba.conf entry for host {HOST}, user {USER}, database {DB_NAME}, no encryption

   PgConnection.cc:161

Desktop (please complete the following information):

• OS: ubuntu
• i am using drogon from conan package manager.

[an-tao]

You could use the following option in the configuration file:

            //connect_options: extra options for the connection. Only works for PostgreSQL now.
            //For more information, see https://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-OPTIONS
            "connect_options": { "statement_timeout": "1s" }

[rafeeque1]

@an-tao i tried , but still getting error ,
can you please give me one example , also include if my postgresql has server.pem and server.key then how to connect along with certificate