https://www.postgresql.org/docs/current/ssl-tcp.html should get you started.
Authentication is documented in
https://www.postgresql.org/docs/current/client-authentication.html
DBI->connect() accepts various parameters in the first argument when
connecting to PostgreSQL, one of them is
I am in the process of moving from an Oracle-based system to Postgres, and am
trying to replicate the setup I have in Oracle.
This is primarily for a variety of web-based applications. None of the database
users exist as user accounts on the client or servers involved; in Oracle the
encryption