PostgreSQL on Ubuntu 20.04 LTS
Ntegral Inc.
PostgreSQL on Ubuntu 20.04 LTS
Ntegral Inc.
PostgreSQL on Ubuntu 20.04 LTS
Ntegral Inc.
PostgreSQL on Ubuntu 20.04 LTS by Ntegral Inc.
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:
- SSH: TCP 22
- 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