i try to use posgresl so i create a new user
CREATE ROLE bob WITH PASSWORD '10add13@';
ALTER ROLE bob WITH SUPERUSER; //to be able to create table maybe not need superuser any suggestion
\password bob
CREATE DATABASE lcm OWNER bob
in my pg_hba.conf file
host lcm bob 127.0.0.1/32 md5
local all all peer
i restarted server
when i tried to connect via jdbc i get
Cannot establish a connection to jdbc:postgresql://localhost:5432/lcm using org.postgresql.Driver (FATAL: role “bob” is not permitted to log in)
tried also
postgres=# ALTER ROLE bob WITH PASSWORD '10add13@';
same result