Secured PostgreSQL on Ubuntu 20.04. PostgreSQL serves its primary function to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications.
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
This image is made specially for customers who are looking for deploying a preinstalled edition instead of just putting up a vanilla install.
Disclaimer:The respective trademarks mentioned in the offering are owned by the respective companies. We do not provide commercial license of any of these products. Many of the products have a, demo or Open Source license as applicable.
Version : PostgreSQL 12.2
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
For Stack specific support : Contact Stack Developer Team(Since we do not own the IP for the stack,Stack developers should be contacted for any support)For more information on the Cognosys PostgreSQL with Ubuntu 20.04 LTS visit our website.