[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
On this page of the site you can watch the video online [GSP355] Manage PostgreSQL Databases on Cloud SQL: Challenge Lab with a duration of hours minute second in good quality, which was uploaded by the user GCP Daemon 20 December 2022, share the link with friends and acquaintances, this video has already been watched 4,167 times on youtube and it was liked by 61 viewers. Enjoy your viewing!
