postgres user psql

PostgreSQL on Ubuntu: Install with Apt and Open psql

PostgreSQL on Ubuntu installs cleanly through stock apt repositories when your indexes are current: apt-get update, install postgresql plus postgresql-contrib, sudo into psql as the postgres role, run SELECT version(), and memorize where postgresql.conf, pg_hba.conf, data directories, and logs live before tightening access.

Read article→