Psql

psql
psql: FATAL:  role "root" does not exist

sudo -u postgres psql
psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
Type "help" for help.
postgres=#

su - posgres && psql
psql (10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
Type "help" for help.
postgres=#

psql -h localhost -U YOUR_USERNAME DB_NAME

Options

• Port (-p): psql -p 5432

Related terms

• pg_hba.conf (PostgreSQL Client Authentication Configuration File)

See also

• PostgreSQL: pg_dump, pgAdmin, Adminer, psql, pg_ctl, docker-compose.xml PostgreSQL, PostgreSQL version, PostgreSQL logs, postgresql.conf, pg_hba.conf