AI Rumman wrote:
> I have configured SSL connection between client/server using
> self-signed certificate.
> ...
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
> .....
> I set the $PGSSLMODE=require to encrypt data across the netwrok.
>
>
> How could I be sure that data is encrypted over the network?
>
use a packet sniiffer like wireshark or tcpdump to examine traffic to
the server hostip on whatever tcp port you're using... if its
plaintext, you would see your SQL commands and their responses coming
across the wire. if its SSL, it will all look like binary gibberish.