GSP355: Create and Manage Cloud SQL for PostgreSQL Instances | Challenge Lab Solution
☁️ Google Cloud Challenge Lab - GSP355
In this video, I'll walk through the complete solution for the Google Cloud Skills Boost Challenge Lab:
“Create and Manage Cloud SQL for PostgreSQL Instances: Challenge Lab”
This is one of the more challenging Cloud SQL labs, covering PostgreSQL database migration, Cloud SQL, Database Migration Service, IAM database authentication, and point-in-time recovery.
I spent several hours working through this lab, testing the steps, troubleshooting errors, and preparing a complete manual solution so you can follow the process from start to finish.
🧪 Lab: GSP355
🎯 Challenge Lab: Create and Manage Cloud SQL for PostgreSQL Instances
💻 Platform: Google Cloud Skills Boost
☁️ Main Topics: Cloud SQL for PostgreSQL, Database Migration Service, PostgreSQL, IAM Database Authentication, Point-in-Time Recovery
In this walkthrough, we'll cover the complete challenge, including:
1. Preparing the stand-alone PostgreSQL database for migration.
2. Configuring the pglogical extension on the PostgreSQL VM.
3. Creating the PostgreSQL migration user and required permissions.
4. Preparing the orders database for migration.
5. Creating a Database Migration Service connection profile.
6. Configuring VPC Peering connectivity.
7. Creating and starting a continuous migration job.
8. Migrating PostgreSQL to Cloud SQL for PostgreSQL.
9. Promoting the migrated Cloud SQL instance to a stand-alone instance.
10. Configuring Cloud SQL IAM database authentication.
11. Adding the PostgreSQL VM network to the Cloud SQL authorized networks.
12. Creating a Cloud SQL IAM user.
13. Granting SELECT permission to the IAM user.
14. Verifying database access with a SQL query.
15. Enabling point-in-time recovery.
16. Creating a database change after the recovery timestamp.
17. Using point-in-time recovery to clone the instance.
18. Creating the required `postgres-orders-pitr` instance.
19. Verifying the completed challenge lab.
🎯 CHALLENGE OVERVIEW
Cymbal Shops wants to migrate its legacy PostgreSQL inventory database to Google Cloud while maintaining data integrity, security, and reliable disaster recovery.
The challenge requires migrating the PostgreSQL `orders` database to Cloud SQL using Database Migration Service, securing the database with IAM database authentication, and configuring point-in-time recovery.
📌 LAB LINK
https://www.skills.google/games/7444/...
📌 WRITTEN SOLUTION
https://github.com/aayush105/google-c...
⚠️ NOTE
This video is intended for educational purposes. Try to understand the commands, configurations, and concepts rather than simply copying the solution.
Challenge lab environments, resource names, and values may vary between lab sessions.
If this walkthrough helped you, consider liking the video and subscribing to Er. Shinux for more Google Cloud Challenge Labs, Skill Badges, Arcade content, cloud tutorials, and developer content.
━━━━━━━━━━━━━━━━━━━━━━
🌐 Portfolio:
https://aayushshrestha7.com.np/
💻 GitHub:
https://github.com/aayush105
🔗 LinkedIn:
/ aayushrestha
📸 Instagram:
/ er.shinux
🎵 TikTok:
/ er.shinux
━━━━━━━━━━━━━━━━━━━━━━
GSP355, Create and Manage Cloud SQL for PostgreSQL Instances, Cloud SQL for PostgreSQL, Cloud SQL Challenge Lab, GSP355 Challenge Lab Solution, Google Cloud Challenge Lab, Google Cloud Skills Boost, GCP Challenge Lab, Database Migration Service, Google Cloud Database Migration Service, PostgreSQL migration, PostgreSQL to Cloud SQL, Cloud SQL IAM database authentication, IAM database authentication, Cloud SQL point in time recovery, PostgreSQL point in time recovery, Cloud SQL PITR, VPC Peering, pglogical, Cloud SQL migration, Google Cloud SQL tutorial, Google Cloud lab solution, GCP lab solution, Google Cloud Arcade, Google Cloud Skill Badge
#GoogleCloud #GSP355 #CloudSQL #PostgreSQL #GoogleCloudSkillsBoost #ChallengeLab #GCP #DatabaseMigration #CloudSQLPostgreSQL #IAM #PointInTimeRecovery #GoogleCloudArcade #CloudComputing #Tech #Coding