Site Loader

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without reading locks.

Installing PostgreSQL

$ sudo apt update
$ sudo apt install postgresql postgresql-contrib

The `postgres` user and then running `psql` to open the Postgres prompt.

$ sudo -u postgres psql

Creating a New Role

$ createuser --interactive


$ sudo -u postgres createuser --interactive

Creating a New Database

$ createdb databaseName


$ sudo -u postgres createdb databaseName

Opening a Postgres Prompt with the New Role

$ sudo adduser sammy

Switch over and connect to the database by typing

$ sudo -i -u sammy
$ psql


$ sudo -u sammy psql

Check Connection Information

$ \conninfo

quit ot exit

$ \q

Setting a password for the `postgres` user

$ \password postgres
Selim Reza

Selim Reza

Software Developer , MBA - NSU.

Follow us on Facebook

Just a Text Widget

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent eu nulla vitae elit interdum sagittis.