PostgreSQL on Ubuntu 20.04 LTS

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

Default ports:

1. SSH: TCP 22
2. DB: TCP 5432

To get started please create a user and database on psql cli as given in the sample below:

EXAMPLE ONLY

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