[GSP355] Manage PostgreSQL Databases on Cloud SQL: Challenge Lab

[GSP355] Manage PostgreSQL Databases on Cloud SQL: Challenge Lab In this challenge lab you will demonstrate your knowledge of Cloud SQL for PostgreSQL that you learned from the Manage PostgreSQL Databases on Cloud SQL quest. /etc/postgresql/13/main/postgresql.conf --------------------------- shared_preload_libraries = 'pglogical' wal_level = 'logical' wal_sender_timeout = 0 max_replication_slots = 10 max_wal_senders = 10 max_worker_processes = 10 listen_addresses = '*' --------------------------- PostgreSQL command used in video: --------------------------- \c postgres; GRANT USAGE ON SCHEMA pglogical TO [user_name]; GRANT ALL ON SCHEMA pglogical TO [user_name]; GRANT SELECT ON pglogical.tables TO [user_name]; GRANT SELECT ON pglogical.depend TO [user_name]; GRANT SELECT ON pglogical.local_node TO [user_name]; GRANT SELECT ON pglogical.local_sync_status TO [user_name]; GRANT SELECT ON pglogical.node TO [user_name]; GRANT SELECT ON pglogical.node_interface TO [user_name]; GRANT SELECT ON pglogical.queue TO [user_name]; GRANT SELECT ON pglogical.replication_set TO [user_name]; GRANT SELECT ON pglogical.replication_set_seq TO [user_name]; GRANT SELECT ON pglogical.replication_set_table TO [user_name]; GRANT SELECT ON pglogical.sequence_state TO [user_name]; GRANT SELECT ON pglogical.subscription TO [user_name]; \c orders; GRANT USAGE ON SCHEMA pglogical TO [user_name]; GRANT ALL ON SCHEMA pglogical TO [user_name]; GRANT SELECT ON pglogical.tables TO [user_name]; GRANT SELECT ON pglogical.depend TO [user_name]; GRANT SELECT ON pglogical.local_node TO [user_name]; GRANT SELECT ON pglogical.local_sync_status TO [user_name]; GRANT SELECT ON pglogical.node TO [user_name]; GRANT SELECT ON pglogical.node_interface TO [user_name]; GRANT SELECT ON pglogical.queue TO [user_name]; GRANT SELECT ON pglogical.replication_set TO [user_name]; GRANT SELECT ON pglogical.replication_set_seq TO [user_name]; GRANT SELECT ON pglogical.replication_set_table TO [user_name]; GRANT SELECT ON pglogical.sequence_state TO [user_name]; GRANT SELECT ON pglogical.subscription TO [user_name]; GRANT USAGE ON SCHEMA public TO [user_name]; GRANT ALL ON SCHEMA public TO [user_name]; GRANT SELECT ON public.distribution_centers TO [user_name]; GRANT SELECT ON public.inventory_items TO [user_name]; GRANT SELECT ON public.order_items TO [user_name]; GRANT SELECT ON public.products TO [user_name]; GRANT SELECT ON public.users TO [user_name]; \c orders; \dt ALTER TABLE public.distribution_centers OWNER TO [user_name]; ALTER TABLE public.inventory_items OWNER TO [user_name]; ALTER TABLE public.order_items OWNER TO [user_name]; ALTER TABLE public.products OWNER TO [user_name]; ALTER TABLE public.users OWNER TO [user_name]; \dt --------------------------- Chapters: 0:52 Task 1. Migrate a stand-alone PostgreSQL database to a Cloud SQL for PostgreSQL instance 14:43 Task 2. Promote a Cloud SQL to be a stand-alone instance for reading and writing data 16:17 Task 3. Implement Cloud SQL for PostgreSQL IAM database authentication 21:49 Task 4. Configure and test point-in-time recovery #GSP355 #qwiklabs #challengelab #gcp #cloudsql #postgresql