patternsqlMinor
What am I doing wrong with pg_hba.conf?
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:
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.
I removed all other uncommented lines from pg_hba.conf and left in only the following one:
host all all ::1/0 trustAfter 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 trustContext
StackExchange Database Administrators Q#48442, answer score: 2
Revisions (0)
No revisions yet.