PostgreSQL is a relational database management system. It is a database specifically targeted for enterprise-scale applications on Azure.
It can handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users. It handles complex SQL queries using many indexing methods that are not available in other databases. PostgreSQL is cross-platform and runs on many operating systems.
In order to use Postgres, log into postgres account.,
You can do that by typing: sudo -i -u postgres
You will be asked for your normal user password and then will be given a shell prompt for the postgres user.
You can get a Postgres prompt immediately by typing: psql
To get started please create a user and database on psql cli as given in the sample below:
CREATE USER myuser SUPERUSER;
ALTER USER myuser WITH PASSWORD 'mypassword';
CREATE DATABASE mydatabase WITH OWNER myuser;
Note: The TCP port the server listens on 5432 by default. It is not opened on Public interface