postgresql - psql: FATAL: role "test" does not exist -
i new postgres , facing difficulty in connecting db after server reboot. have created database pgdb under os user test. after server restarted, restarted pgsql issuing command
service postgresql-9.6 start
starting postgresql-9.6 service: [ ok ]
if issue psql, taken psql prompt data path here different have set previously. when try connect pgdb postgres user, error:
psql: fatal: database "pgdb" not exist
when try connect test user:
psql -d pgdb
psql: fatal: role "test" not exist
please suggest
Comments
Post a Comment