PostgreSQL is known by the industry as an “advanced open source database”. It targets the OLTP online transaction processing scenario of complex SQL processing in enterprises. It supports NoSQL data types (JSON/XML/HStore) and GIS geographic information processing.

COMPONENTS:
PostgreSQL 15.2, pgAdmin 6.20, Docker 23.0 on Ubuntu 22.04

Minimum configuration:
1 core 1G

Object-oriented:
Webmaster, designer, developer, operation and maintenance, product manager, enterprise, student

Application scenarios:
database server

User guide:
After the image is installed on the cloud server, go to: http://服务器公网IP:9090 and go to pgAdmin. To connect to PostgreSQL remotely, please enable port 5432. If you can't access it, check if security group ports 9090 and 5432 are open. See: Amazon Web Services Security Group Settings

Online documentation:
PostgreSQL administrator manual