Cloudbooklet
  • News
  • Artificial Intelligence
  • Applications
  • Linux
No Result
View All Result
Cloudbooklet
  • News
  • Artificial Intelligence
  • Applications
  • Linux
No Result
View All Result
Cloudbooklet
No Result
View All Result
Home Google Cloud

Setup Cloud SQL for PostgreSQL on Google Cloud

by Cloudbooklet
4 years ago
in Google Cloud, Cloud SQL
Setup Cloud Sql For Postgresql On Google Cloud
ShareTweetSendShare
Readers like you help support Cloudbooklet. When you make a purchase using links on our site, we may earn an affiliate commission.

In this post, you are going to create a Cloud SQL for PostgreSQL in Google Cloud Platform and connect it to Compute Engine VM Instance. Prerequisites Your Compute Engine Instance is setup and running. For setting up Compute Engine, see the Setting up Compute Engine Instance. Domain name is pointed to your virtual machine. For […]

ADVERTISEMENT

In this post, you are going to create a Cloud SQL for PostgreSQL in Google Cloud Platform and connect it to Compute Engine VM Instance.

Prerequisites

  1. Your Compute Engine Instance is setup and running.
  2. For setting up Compute Engine, see the Setting up Compute Engine Instance.
  3. Domain name is pointed to your virtual machine.
  4. For setting up Cloud DNS, see the Setting up Google Cloud DNS for your domain.

Get your Professional Google Cloud Architect certificate with this easy to learn course now.

Creating a Second Generation instance

  1. Go to Storage >> Cloud SQL in GCP console.
  2. Click Create Instance.
  3. Select PostgreSQL and click next.
  4. Enter instance name (recommended to use your domain name without the .com or .co.eu extension).
  5. Enter the password for the default user and copy it safe.
  6. Set the region for your PostgreSQL instance the same as you set in your Compute Engine VM Instance.
Create Postgresql Instance

Under Configuration options update the following

ADVERTISEMENT
  1. Click set Connectivity, and under Authorized Networks click Add Networks.
  2. Enter the name in the Name field (this is optional).
  3. Enter your Compute Engine Instance IP address in the Network field.
  4. Click Done.

This setting will authorize your Compute Engine VM Instance to connect to this Cloud SQL Instance.

You might also like

How To Setup Ssh Keys On Ubuntu

How to Setup SSH Keys on Ubuntu 20.04

4 months ago
Draggan Ai Editing Tool Install And Use Draggan Photo Editor

DragGAN AI Editing Tool Install and Use DragGAN Photo Editor

4 months ago
Connect Vm Instance To Cloud Sql

Click Configure machine type and storage and choose Micro Instance

Choose SSD in Storage type

ADVERTISEMENT

Leave everything to default and click create.

It will take some time to create a new Cloud SQL instance.

ADVERTISEMENT

Creating a database and a user

Once your instance is created click on the instance name to view all details of the instance.

Here in the Overview tab, you can find the Public IP address in the Connect to this instance.

ADVERTISEMENT

This IP address is the PostgreSQL hostname you need to provide while setting up your application.

Postgresql Instance Details

Now click on the Database tab and create a new database by clicking the Create Database button.

ADVERTISEMENT

Get your Professional Google Cloud Architect certificate with this easy to learn course now.

Conclusion

Now you have created a new Cloud SQL instance for PostgreSQL on Google Cloud Platform and connected it with the Compute Engine Instance.

Tags: Cloud SQLGoogle Cloud Platform
ShareTweetSendShare
Cloudbooklet

Cloudbooklet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Related Posts

Set Up Deep Learning With Nvidia, Cuda, Cudnn On Ubuntu

How to Set Up Deep Learning with Nvidia, CUDA, cuDNN on Ubuntu 22.04

7 months ago
How To Install Or Upgrade Php 8.2 On Ubuntu 22.04

How to Install or Upgrade PHP 8.2 on Ubuntu 22.04

9 months ago
How To Change Timezone On Ubuntu 22.04

How to Change Timezone on Ubuntu 22.04

1 year ago
How To Install Ansible On Ubuntu 22.04

How to Install Ansible on Ubuntu 22.04

1 year ago

Follow Us

Trending Articles

Ai Comic Generator

Best 10 AI Comic Generator: Create Comic book in Seconds

September 18, 2023

Microsoft Unveils New Disc-Less Xbox Series X with Lift-to-Wake Controller

WhatsApp Business Gets New Features to Help your Businesses Grow

10 Best AI Song Generator in 2023 (Free and Paid)

AI Statistics and Trends: What You Need to Know in 2023

How to Delete Netflix Account Permanently

Popular Articles

Validator Ai

Validator AI: The AI Powered Business Idea Validator

September 20, 2023

OpenAI Introduces ChatGPT Enterprise for Businesses

Google and Bing in Action to Prevent Spread of AI Child Porn

How to Fix TikTok Comment Glitch in 5 Easy Steps

Top 9 Slideshow Makers for Bloggers and Content Creators

3 Ways to Use Stable Diffusion AI Art Generator for Free

Subscribe Now

loader

Subscribe to our mailing list to receives daily updates!

Email Address*

Name

Cloudbooklet Logo

Welcome to our technology blog, where we explore the latest advancements in the field of artificial intelligence (AI) and how they are revolutionizing cloud computing. In this blog, we dive into the powerful capabilities of cloud platforms like Google Cloud Platform (GCP), Amazon Web Services (AWS), and Microsoft Azure, and how they are accelerating the adoption and deployment of AI solutions across various industries. Join us on this exciting journey as we explore the endless possibilities of AI and cloud computing.

  • About
  • Contact
  • Disclaimer
  • Privacy Policy

Cloudbooklet © 2023 All rights reserved.

No Result
View All Result
  • News
  • Artificial Intelligence
  • Applications
  • Linux

Cloudbooklet © 2023 All rights reserved.