How to create PostgreSQL Database Server in GCP

In this article, I walkthrough you how to create a Postgres SQL server in GCP SQL 

Introduction: -



All you know about that leading public cloud providers are Azure and AWS, both are providing Database as a Service, like that GCP also offering Database as a Service in both SQL and No-SQL Database servers for customers and users.


How to create PostgreSQL in GCP SQL



Let’s start how to create a Postgres SQL Server in GCP SQL


Before going to start log into GCP Account 

To Create a Postgresql Databases Server→ Click SQL in Google services Pane


To Create a SQL Instance → Click CREATE INSTANCE


Choose which database you want → Click PostgreSQL




Fill the Configuration Details


Instance ID: - Give the name for the instance
Set Password
Select the Region which nearby you
Select the version of the Database server.
Click the Show Configuration options to configure more detail.


Expand the Configuration details




Click Connectivity → By default instance can’t access from the outside or external networks → to access the instance allow the particular IP or Public access to the instance → Click + Add network







By giving 0.0.0.0/0 in network it will allow all IPv4 IP’s, we can access the instance from anywhere.



You can see it was saving.






To communicate with additional resources and API → enable Private IP and select Associated network (VPC network which you created or select the default).




You can see it was saving details to connect




You can also check from Private connections by clicking VPC 🡪 VPC Peering



Select Machine type and storage (core and memory)




If you are going to test or practice the instance select single zone 












If it is a production environment select the High availability, it will increase the cost.




Click to Add item to add database flags




Choose any one of the flags if required


.


GCP will update the Database every few months, so GCP offers us to select the day and time to restart your database it will not take more time.


So, select day and time, if your database is in production 



Give the key value to your reference in labels tab




Click create to create the database



GCP was creating PostgreSQL server.


Oh Great!!, PostgreSQL server was created successfully.




You can see the details and overview of created PostgreSQL.




By clicking Connections, you can see the connection details, and you can also see the database has been authorised to communicate with GCP App Engine.



To access the created PostgreSQL server, we can create user from here itself. 


You can also create database from here.




You can manage backups from here.










Also create replica for this instance




You can also have a look here to find, what are the tasks has been done. 




I hope you are enjoyed and this article was useful to you, to create a GCP PostgreSQL Server.

Thanks for reading this article.

Comments

Popular posts from this blog

Docker for Beginners

Azure Active Directory and Its Key Features

Short Note of Azure Virtual Networking (VNET, SUBNET, NSG, VNET PEERING, VPN GATEWAY, EXPRESS ROUTE)

Azure Storage services and types storage accounts

Kubernetes Installation in Redhat / CentOS

Short Note on AWS Networking VPC, SUBNET, NACL, SECURITY GROUPS, VPC PEERING, SITE TO SITE VPN, DIRECT CONNECT

Azure Storage Replication Strategies.

Oracle to MS SQL Migration

Road Map for Successful On-premises Data center Application Servers to Microsoft Office 365 Cloud and Azure