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 "sslmode", which can be set to
"disable", "allow", "prefer", and "require" (from insecure to secure).
On 08.09.2023 19:41, Johnson, Bruce E - (bjohnson) wrote:
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 process is handled by the client
software. From reading the docs it is unclear where it is handled in
the Postgresql client.
How does DBD::Pg manage login encryption? For example SSL…
--
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group
Institutions do not have opinions, merely customs
--
Alexander Foken
mailto:alexan...@foken.de
