[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-users
Subject:    Re: DBD::Pg authentication methods
From:       Alexander Foken <alexander () foken ! de>
Date:       2023-09-08 18:45:38
Message-ID: 73299429-5488-4067-bbca-3f776a397e77 () foken ! de
[Download RAW message or body]

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:alexander@foken.de

[prev in list] [next in list] [prev in thread] [next in thread]