================================================================
handson: rds (opelab: db instance public)
================================================================

.. toctree::
   :maxdepth: 1
   :glob:

   ./*

.. ::

..   echo "select version();" \
..     | psql --host=${RDS_INSTANCE_ENDPOINT} --username=${RDS_USER_NAME} --dbname=${RDS_DB_NAME} 


----------------------------------------------------------------
手順書作成手順
----------------------------------------------------------------

0.事前準備   
++++++++++++++++++++++++++++++++

- VPCの作成

::

  cp ../../../resource-catalog/task-ec2/ec2-vpc-create/_defines-vpc.txt .

  cp ../../../resource-catalog/task-ec2/ec2-vpc-create/ec2-vpc-create.rst 0-1-1-ec2-vpc-create.rst


- VPCの属性変更

::

  cp ../../../resource-catalog/task-ec2/ec2-vpc_attribute-update/ec2-vpc_attribute-enableDnsHostnames-true-update.rst 0-1-2-ec2-vpc_attribute-enableDnsHostnames-true-update.rst


  - http://docs.aws.amazon.com/cli/latest/reference/ec2/modify-vpc-attribute.html

- IGWの作成

::

  cp ../../../resource-catalog/task-ec2/ec2-igw-create/ec2-igw-create.rst 0-2-1-ec2-igw-create.rst

- IGWのアタッチ

::

  cp ../../../resource-catalog/task-ec2/ec2-igw_attach-update/ec2-igw_attach-update.rst 0-2-2-ec2-igw_attach-update.rst

- ルートテーブルの作成

::

  cp ../../../resource-catalog/task-ec2/ec2-route_table-create/_defines-vpc-route_table.txt .

::

  cp ../../../resource-catalog/task-ec2/ec2-route_table-create/ec2-route_table-create.rst 0-3-1-ec2-route_table-create.rst

- ルートの作成

::

  cp ../../../resource-catalog/task-ec2/ec2-route-create/ec2-route-create.rst 0-3-2-ec2-route-create.rst

- Subnet1の作成 (public)

::

  cp ../../../resource-catalog/task-ec2/ec2-subnet-create/_defines-vpc-subnet-1.txt .

::

  cp ../../../resource-catalog/task-ec2/ec2-subnet-create/ec2-subnet-create.rst 0-4-1-ec2-subnet-create.rst

- Subnet2の作成 (public)

::

  cp ../../../resource-catalog/task-ec2/ec2-subnet-create/_defines-vpc-subnet-1.txt _defines-vpc-subnet-2.txt

::

  cp ../../../resource-catalog/task-ec2/ec2-subnet-create/ec2-subnet-create.rst 0-5-1-ec2-subnet-create.rst

- ルートテーブルのアタッチ(1)

::

  cp ../../../resource-catalog/task-ec2/ec2-route_table_associate-update/ec2-route_table_associate-update.rst 0-4-2-ec2-route_table_associate-update.rst

- ルートテーブルのアタッチ(2)

::

  cp ../../../resource-catalog/task-ec2/ec2-route_table_associate-update/ec2-route_table_associate-update.rst 0-5-2-ec2-route_table_associate-update.rst

- セキュリティグループの作成

::

  cp ../../../resource-catalog/task-ec2/ec2-security_group-create/_defines-vpc-sg-1.txt .

::

  cp ../../../resource-catalog/task-ec2/ec2-security_group-create/ec2-security_group-create.rst 0-6-1-ec2-security_group-create.rst

- セキュリティグループのルール追加

::

  cp ../../../resource-catalog/task-ec2/ec2-security_group_ingress_authorize-update/ec2-security_group_ingress_authorize-cidr-update.rst 0-6-2-ec2-security_group_ingress_authorize-cidr-update.rst


1. RDSの構築
++++++++++++++++++++++++++++++++

- DBサブネットグループの作成

::

  cp ../../../resource-catalog/task-rds/rds-db_subnet_group-create/_defines-rds.txt .

::

  cp ../../../resource-catalog/task-rds/rds-db_subnet_group-create/rds-db_subnet_group-create.rst 1-1-rds-db_subnet_group-create.rst


- DBインスタンスの作成 (singleAZ public)

::

  cp ../../../resource-catalog/task-rds/rds-db_instance-create/rds-db_instance-postgresql-single_az-publicly_accessible-create.rst 1-2-rds-db_instance-postgresql-single_az-publicly_accessible-create.rst



2. DBでの作業
++++++++++++++++++++++++++++++++

2.1. DBへのアクセス

::

  cp ../../../resource-catalog/task-postgresql/postgresql-misc-read/psql-connect.rst 2-1-psql-connect.rst 


2.2. ロールの作成 (psql)

::

  cp ../../../resource-catalog/task-postgresql/postgresql-misc-create/psql-role-create.rst 2-2-psql-role-create.rst 


2.3. データベースの作成 (psql)

::

  cp ../../../resource-catalog/task-postgresql/postgresql-misc-create/psql-database-create.rst 2-3-psql-database-create.rst 


後始末
++++++++++++++++++++++++++++++++

z.1.1. データベースの削除 (psql)

::

  cp ../../../


z.1.2. ロールの削除 (psql)

::

  cp ../../../


z.2.1. DBインスタンスの削除

https://qiita.com/tcsh/items/d7ca66fe8251f865c668

::

  cp ../../../resource-catalog/task-rds/rds-db_instance-delete/rds-db_instance-delete.rst z-2-1-rds-db_instance-delete.rst


z.2.2. DBサブネットグループの削除

::

  cp ../../../resource-catalog/task-rds/rds-db_subnet_group-delete/rds-db_subnet_group-delete.rst z-2-2-rds-db_subnet_group-delete.rst