database.default.dsn not working

CI4 does not use the PDO driver.
To use a DSN for CI drivers, the string must follow the format: DBDriver://username:password@hostname:port/database
But in your case, your DSN should work specifying the driver through a property.

database.default.DBDriver = Postgre