Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Client Authentication methods - Mailing list pgsql-general

From chiru r
Subject [GENERAL] Client Authentication methods
Date
Msg-id CA+RSxMhfEUPdpcWO2bWrBzXgvVXbdckvP=qB1WCO7M9TUCeMsw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Client Authentication methods  (Berend Tober <btober@computer.org>)
Re: [GENERAL] Client Authentication methods  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
Tree view
Hi All,

I am trying to understand the Authentication method in pg_hba.conf file (password & md5) in PostgreSQL database server. 

I am assuming that the user provides the  connection string host/usser/password,then client will go and contact the DB server pg_hba.conf file in memory without carrying password over the network initially, and then it confirms the authentication method from pg_hba.conf ,then it decides weather it send clear text or md5 encrypted password from client to Server to make a session?

Is my assumption is correct ? or What exactly it make the difference for client if i use md5/password  in pg_hba.conf file in DB server?.

Thanks,
chiru


pgsql-general by date:

Previous
From: Arthur Zakirov
Date:
Subject: Re: [GENERAL] Spelling dictionaries
Next
From: Berend Tober
Date:
Subject: Re: [GENERAL] Client Authentication methods