PostgreSQL is a powerful, open-source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.
Install PostgreSQL on Ubuntu by using the following command
apt update apt install postgresql postgresql-contrib
root@crown:~# apt install postgresql postgresql-contrib Reading package lists... Done Building dependency tree... Done Reading state information... Done postgresql-contrib is already the newest version (13+225ubuntu1). The following packages were automatically installed and are no longer required: libfile-find-rule-perl libnumber-compare-perl libtext-glob-perl Use 'apt autoremove' to remove them. Suggested packages: postgresql-doc The following NEW packages will be installed: postgresql
We'll switch to Postgres account for the next steps, to switch to the postgres account, use the following command,
sudo -i -u postgres
You can access a PostgreSQL prompt using the psql utility
postgres@crown:~$ psql psql (14.2 (Ubuntu 14.2-1)) Type "help" for help. postgres=#
Exit out of the PostgreSQL shell type
Create PostgreSQL Role,
sudo -u postgres createuser --interactive
Enter name of role to add: john Shall the new role be a superuser? (y/n) y
Create a PostgreSQL database,
sudo -u postgres createdb john
Open a Postgres Prompt with the New Role.
sudo adduser john
Switch over and connect to the database.
sudo -u john psql
root@crown:~# sudo -u john psql could not change directory to "/root": Permission denied psql (14.2 (Ubuntu 14.2-1)) Type "help" for help. john=#
Once you logged in as john and check your current connection information.
john=# \conninfo You are connected to database "john" as user "john" via socket in "/var/run/postgresql" at port "5432". john=#