Hello
configuration: pgdac 9.0 standard, delphi 11.2, database Google AlloyDB (Cloud Database & postgresql share same issue anyway)
AlloyDB is configured for public ips and "require SSL"; connection from PgAdmin on dev machine ok.
blank project, PgConnection pointing to ip address, port 5432, user specified, password specified, SSLOptions Mode = smRequire. At design time press connect and I have green light. I am also able to connect a query with sql, open and see data in dbgrid.
If I compile and execute, bum. error.. You can see the whole process in attached video.
Seems there's some intrinsic and artificial limitation in order to having this not working at runtime.
I reviewed editions comparison in your web site (
PostgreSQL Data Access Components - Editions ) but I don't see nothing about this limit cited there. I do see in compatibilty that Alloydb and Cloud database are generically "supported". This is a simple SSL requirement, not certificates etc, so it should not require SecureBridge to work.
So what's the problem with this?
This is a fairly simple and limited project, so in case there's such limitation there's no budget for more expensive editions, I will simply configure to accept uncrypted traffic, but anyway...