Install and Connect to Postgres DB on The Cloud
In this video, you will learn creating and configuring Postgres on Azure, firewall configuration, connecting to Postgres on Azure using Linux local machine using SSH and many other steps.
Create production Postgres Database
After that I will connect to the Postgres on Azure using the Linux machine using SSH, then create a production then Configure the Postgres server firewall rule
About the Author
---------------
Video:
• Mohamed Radwan is a Principal DevOps ...
Blog:
https://mohamedradwan.com
Linked-in
/ mohamedahmedradwan
Some commands
Azure
----------
Create a resource group
--------------------------------------
az group create --name RGLabRadwan --location "East US"
Create postgres DB
--------------------------------------
az postgres server create --location "East US" --resource-group RGLabRadwan --name postgrasradwanserver --admin-user userradwan --admin-password DevOpsAKS@1234 --sku-name GP_Gen5_2
Postgres Firewall
--------------------------------------
az postgres server firewall-rule create --resource-group RGLabRadwan --server postgrasradwanserver --name AllowAllIps --start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0
psql -U userradwan@postgrasradwanserver -h postgrasradwanserver.postgres.database.azure.com postgres
CREATE DATABASE sampledb;
CREATE USER radwanuserdb WITH PASSWORD 'DevOpsAKS@1234';
GRANT ALL PRIVILEGES ON DATABASE sampledb TO radwanuserdb;
#Postgres_training #Azure_development #Azure_Postgres