19. Administering an AlloyDB Database

Task 1. Examine a Database Flag데이터베이스 플래그 검사클릭 1.To add a database flag to your instance, expand Advanced Configuration Options and click on Add a Database Flag. 2.Browse the list of avaiable flags (inside Choose a flag) to get a sense of the supported options. You will not add an additional flag as part of this lab.3.Click Cancel twice to exit the Edit Primary instance screen. Task 2. Setup a D..

18. Migrating to AlloyDB from PostgreSQL Using Database Migration Service

Task 1. Verify Data in the Source Instance for migration sudo -u postgres psql\dt   select count (*) as countries_row_count from countries;select count (*) as departments_row_count from departments;select count (*) as employees_row_count from employees;select count (*) as jobs_row_count from jobs;select count (*) as locations_row_count from locations;select count (*) as regions_row_count from re..

17. AlloyDB - Database Fundamentals

PostgreSQL 인스턴스와 데이터베이스용 AlloyDB 생성 및 관리 test Task 1. Create a cluster and instance Task 2. Create tables and insert data in your databaseexport ALLOYDB=ALLOYDB_ADDRESSecho $ALLOYDB  > alloydbip.txtpsql -h $ALLOYDB -U postgres CREATE TABLE regions (    region_id bigint NOT NULL,    region_name varchar(25)) ;ALTER TABLE regions ADD PRIMARY KEY (region_id); INSERT INTO regions VALUES ( 1, 'Europe'..

Cloud SQL for PostgreSQL 인스턴스에 앱 연결(애플리케이션이 데이터베이스에 쓰고 읽을 수 있는지 확인) Task 1. Initialize APIs and create a Cloud IAM service account1.In Cloud Shell, run the following command to enable the Artifact Registry API:gcloud services enable artifactregistry.googleapis.com Create a Service Account for Cloud SQL1.In Cloud Shell, create a Service Account and bind it to the Cloud SQL admin role in the lab p..

Task 1. Prepare the source database for migration sudo apt install postgresql-13-pglogical sudo su - postgres -c "gsutil cp gs://cloud-training/gsp918/pg_hba_append.conf ."sudo su - postgres -c "gsutil cp gs://cloud-training/gsp918/postgresql_append.conf ."sudo su - postgres -c "cat pg_hba_append.conf >> /etc/postgresql/13/main/pg_hba.conf"sudo su - postgres -c "cat postgresql_append.conf >> /et..

'다른 리전에서 bigquery 테이블을 복사하기' 인데 composer에 대해 공부하고 싶어서 수행했다. Task 1. Create a Cloud Composer environment  수행 과제 :Click the dropdown for Show Advanced Configuration and select Airflow database zone as us-east4-b. Task 2. Create Cloud Storage bucketscomposer 생성시 자동으로 storage 생성됨 Create a bucket in US Create a bucket in EU  Task 3. Create the BigQuery destination dataset Task 4. Airflow and core con..