Firedac and PostGreSQL Over SSL

[PaulRichardson 0]

Hello

 

Having searched google, G+ and these forums I'm trying to find if anyone is able to use FireDac with an SSL encrypted PostGreSQL connection.

If so could you provide details as I can't seem to find anywhere to enable an SSL connection in FireDac.

Thank You

 

Paul

[Dmitry Arefiev 106]

You need to use sslxxxx PostgreSQL connection parameters:

https://www.postgresql.org/docs/11/libpq-connect.html#LIBPQ-PARAMKEYWORDS

And put them into FireDAC PGAdvanced connection parameter:

http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Connect_to_PostgreSQL_(FireDAC)#Connection_Definition_Parameters