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
Post a Comment