What does PostgreSQL mean?
PostgreSQL is an open-source, object-relational database management system (ORDBMS) that is not owned or controlled by one company or individual. Because PostgreSQL software is open-source, it is managed mostly through a coordinated online effort by an active global community of developers, enthusiasts and other volunteers.
First released in the mid-1990s, postgresSQL is written in C. Its primary competitors include Oracle DB, SQL Server and MySQL.
This term is also known as Postgres.
First, let us update the system:
~$ sudo apt-get update && sudo apt-get upgrade
Install PostgreSQL from the Ubuntu package repository:
~$ sudo apt-get install postgresql postgresql-contrib
host all all 127.0.0.1/32 md5
host all all 0.0.0.0/0 md5
Switching Over to the postgres Account
The installation procedure created a user account called
postgres that is associated with the default Postgres role. In order to use Postgres, we can log into that account.
Switch over to the
postgres account on your server by typing:
You will be logged in and able to interact with the database management system right away.