How to allow postgres login without password prompt on local connection?

Question

How do you configure PostgreSQL to allow the default postgres user to login without a password from localhost?

There are several similar questions, such as this and this, but none of the suggestions to modify pg_hba.conf have worked for me. However, based on my understanding of the pg_hba.conf rules, I should be able to accomplish this with either the peer or trust options.

I'm trying to run a command like:

sudo psql --user=postgres --no-password --command="blah;" -h 127.0.0.1

If I try this line in my pg_hba.conf:

local   all             postgres                                trust

my command fails with the error:

psql: FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres", SSL on
FATAL:  no pg_hba.conf entry for host "127.0.0.1", user "postgres", database "postgres", SSL off

If I tried this line:

local   all             postgres                                peer

my command fails with the same error.

How do I fix this?

user330315 · Accepted Answer · 2017-10-13 19:58:18Z

15

When you specify -h 127.0.0.1 that is not a "local" connection - it's a host (=TCP based) connection. So a line starting with local will not match for such a connection.

To make that entry work, do not specify a hostname or port for psql, then it will use a "local" connection through named pipes.

Alternatively, you can local with host and then add 127.0.0.1 as the (client) IP address to "trust".

answered Oct 13, 2017 at 19:58

user330315

Sign up to request clarification or add additional context in comments.

1 Comment

Ashish Kumar Over a year ago

Sorry I am newbie to postgres, please share the complete psql command.

Collectives™ on Stack Overflow

How to allow postgres login without password prompt on local connection?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related