psql - Postgres not looking at the right pg_hba.conf file? -



psql - Postgres not looking at the right pg_hba.conf file? -

i uninstalled postgres (not sure if did properly. used homebrew uninstall , manually deleted whatever showed on locate psql in terminal. installed postgres.app , tried running it. prompts password (that don't remember or don't know exists or not) though went pg_hba.conf file found in

edmunds-macbook-pro:~ edmundmai$ locate pg_hba /usr/share/postgresql/pg_hba.conf

and changed trust everything:

# type database user cidr-address method local trust # ipv4 local connections: host 127.0.0.1/32 trust # ipv6 local connections: host ::1/128 trust

am missing something? can't psql run because prompts password. i'm willing uninstall if fixes it.

try restarting server. editing pg_hba.conf isn't plenty on own.

on ubuntu postgres 9.1 next worked me

sudo /etc/init.d/postgresql restart

for more info see documentation on ubuntu help pages

psql

Comments

Popular posts from this blog

web services - java.lang.NoClassDefFoundError: Could not initialize class net.sf.cglib.proxy.Enhancer -

Accessing MATLAB's unicode strings from C -

javascript - mongodb won't find my schema method in nested container -