when i create a new user, but it cannot login the database.
I do that like this:
[email protected]:/home/XXX$ createuser dev
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) y
then create a database:
[email protected]:/home/XXX$ createdb -O dev test_development
after that, I try psql -U dev -W test_development to login, but get the error:
psql: FATAL: Peer authentication failed for user "dev"
I tried to solve the problem but failed.
This question is related to
postgresql
Try:
psql -U user_name -h 127.0.0.1 -d db_name
where
-U is the database user name-h is the hostname/IP of the local server, thus avoiding Unix domain sockets-d is the database name to connect toThis is then evaluated as a "network" connection by Postgresql rather than a Unix domain socket connection, thus not evaluated as a "local" connect as you might see in pg_hba.conf:
local all all peer