[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