How to Setup PostgreSQL Server + pgAdmin Web Tool on Ubuntu in GCP (Database Server)

How to Setup/Install PostgreSQL Server on GCP: PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying. So, you want NoSQL, Riak, REACT, Redis, Mongo, etc.? PostgreSQL does all that.

pgAdmin is a web-based management tool for PostgreSQL allowing your manage PostgreSQL via your browser.

This video will show how you can setup PostgreSQL + pgAdmin Web Tool on GCP

Enjoy the Video.

⏰Timestamps⏰
00:00 Intro PostgreSQL Server
00:24 Creating PostgreSQL on Ubuntu
01:03 Accessing SSH terminal
01:15 Configuring PostgreSQL
02:18 Accessing Postgre Shell
02:36 Running Basic Commands
02:56 Allow Remote Connections
04:24 Setup pgAdmin
04:46 Accessing pgAdmin Web Tool
05:25 Outro PostgreSQL Server on GCP

🔗 PostgreSQL Server + pgAdmin on Ubuntu Server 20.04 on GCP Marketplace listing:
https://console.cloud.google.com/marketplace/product/cloud-infrastructure-services/postgresql-ubuntu

🔗 PostgreSQL Server + pgAdmin on CentOS Server 8.3 on GCP Marketplace listing:
https://console.cloud.google.com/marketplace/product/cloud-infrastructure-services/postgresql-centos

🔗 How to Setup/Install PostgreSQL Server on GCP Blog Post:
https://cloudinfrastructureservices.co.uk/how-to-setup-install-postgresql-server-on-azure-aws-gcp/

PostgreSQL Server Features:
-Compatible with Data Integrity
-Support multiple features of SQL
-Compatible with multiple data types
-Concurrency, Performance
-Internationalisation, Text Search
-Highly extensible
-Secure
-Highly Reliable
-pgAdmin - Web based management tool.
-Supports geospatial databases for geographic information systems (GIS).
-Robust database in the LAPP stack
-Many languages supported: Python, Java, C#, C/C+, Ruby, JavaScript (Node.js), Perl, Go, Tcl

Видео How to Setup PostgreSQL Server + pgAdmin Web Tool on Ubuntu in GCP (Database Server) канала Cloud Infrastructure Services