Psql

From wikieduonline
Jump to navigation Jump to search


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[edit]

  • Port (-p): psql -p 5432

Related terms[edit]

  • pg_hba.conf (PostgreSQL Client Authentication Configuration File)

See also[edit]