HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

What am I doing wrong with pg_hba.conf?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
confwhatwithpg_hbadoingwrong

Problem

I'm trying to make it so that local connections to the database don't require a login. So I added the line local all all trust to the pg_hba.conf file, but then when I load pgAdmin and try to connect to the server it just says FATAL: could not load pg_hba.conf. What am I doing wrong?

Solution

The problem is that this postgres version under win7 can not handle local connections. I had to work with pg very urgently on my local computer so I did not care too much about security so maybe this is not the best solution for a live environment. But my local PC it was enough.

I removed all other uncommented lines from pg_hba.conf and left in only the following one:

host    all             all             ::1/0                 trust


After this I could connect via command line.

I do not understand why the manual tells no more about this issue. I am pretty sure many people have problem with this.

Code Snippets

host    all             all             ::1/0                 trust

Context

StackExchange Database Administrators Q#48442, answer score: 2

Revisions (0)

No revisions yet.