psql asks for password despite configuring trust authentication

Started by Atul Kumarover 5 years ago3 messagesgeneral
Jump to latest
#1Atul Kumar
akumar14871@gmail.com

hi,

My problem is, that I am always asked for password when trying to
interact with the database or access it, although the authentication
is set to trust for all users and databases.

Please help.

Regards,
Atul

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: Atul Kumar (#1)
Re: psql asks for password despite configuring trust authentication

On 10/29/20 10:59 AM, Atul Kumar wrote:

hi,

My problem is, that I am always asked for password when trying to
interact with the database or access it, although the authentication
is set to trust for all users and databases.

What is the connection command you are using?

Did you reload the server after making changes to pg_hba.conf?

Are you sure you are pointing at the right database?

What are the contents of your pg_hba.conf file?

Please help.

Regards,
Atul

--
Adrian Klaver
adrian.klaver@aklaver.com

#3Ganesh Korde
ganeshakorde@gmail.com
In reply to: Atul Kumar (#1)
Re: psql asks for password despite configuring trust authentication

Please make sure you are not using -w option while connecting through psql.

On Thu, 29 Oct 2020, 11:30 pm Atul Kumar, <akumar14871@gmail.com> wrote:

Show quoted text

hi,

My problem is, that I am always asked for password when trying to
interact with the database or access it, although the authentication
is set to trust for all users and databases.

Please help.

Regards,
Atul