数秒で起動して VPC 不要でどこからでも接続できる Amazon Aurora PostgreSQL エクスプレス設定が一般提供になったので実際に起動時間を計測した

$ aws --version
aws-cli/2.34.17 Python/3.14.3 Linux/6.1.163-186.299.amzn2023.x86_64 exec-env/CloudShell exe/x86_64.amzn.2023

aws rds create-db-cluster \
  --db-cluster-identifier my-express-db-1 \
  --engine aurora-postgresql \
  --with-express-configuration \
  --region ap-northeast-1

{
    "DBCluster": {
        "AllocatedStorage": 1,
        "AvailabilityZones": [
            "ap-northeast-1c",
            "ap-northeast-1d",
            "ap-northeast-1a"
        ],
        "BackupRetentionPeriod": 1,
        "DBClusterIdentifier": "my-express-db-1",
        "DBClusterParameterGroup": "default.aurora-postgresql17",
        "Status": "creating",
        "MultiAZ": false,
        "Engine": "aurora-postgresql",
        "EngineVersion": "17.7",
        "Port": 5432,
        "MasterUsername": "postgres",
        "PreferredBackupWindow": "13:44-14:14",
        "PreferredMaintenanceWindow": "thu:17:46-thu:18:16",
        "UpgradeRolloutOrder": "second",
        "ReadReplicaIdentifiers": [],
        "DBClusterMembers": [
            {
                "DBInstanceIdentifier": "my-express-db-1-instance-1",
                "IsClusterWriter": false,
                "DBClusterParameterGroupStatus": "in-sync",
                "PromotionTier": 1
            }
        ],
        "VpcSecurityGroups": [],
        "StorageEncrypted": false,
        "StorageEncryptionType": "sse-rds",
        "DbClusterResourceId": "cluster-ABCDEFGHIJKLMNOPQRSTUVWXYZ",
        "DBClusterArn": "arn:aws:rds:ap-northeast-1:123456789012:cluster:my-express-db-1",
        "AssociatedRoles": [],
        "IAMDatabaseAuthenticationEnabled": true,
        "ClusterCreateTime": "2026-03-26T05:05:17.845000+00:00",
        "EngineMode": "provisioned",
        "AutoMinorVersionUpgrade": true,
        "DeletionProtection": false,
        "HttpEndpointEnabled": false,
        "CopyTagsToSnapshot": false,
        "CrossAccountClone": false,
        "DomainMemberships": [],
        "TagList": [],
        "ServerlessV2ScalingConfiguration": {
            "MinCapacity": 0.0,
            "MaxCapacity": 16.0,
            "SecondsUntilAutoPause": 300
        },
        "ServerlessV2PlatformVersion": "3",
        "DatabaseInsightsMode": "standard",
        "PerformanceInsightsEnabled": false,
        "LocalWriteForwardingStatus": "disabled",
        "EngineLifecycleSupport": "open-source-rds-extended-support",
        "VPCNetworkingEnabled": false,
        "InternetAccessGatewayEnabled": true
    }
}

export RDSHOST=""my-express-db-1-instance-1.cluster-abcdefghijkl.ap-northeast-1.rds.amazonaws.com" 
psql "host=$RDSHOST port=5432 dbname=postgres user=postgres sslmode=require password=$(aws rds generate-db-auth-token --hostname $RDSHOST --port 5432 --username postgres --region ap-northeast-1)"
psql (15.16, server 17.7)
WARNING: psql major version 15, server major version 17.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

postgres=> 

START=$(date +%s) && echo "開始: $(date '+%H:%M:%S')"

aws rds create-db-cluster \
  --db-cluster-identifier my-express-db-2 \
  --engine aurora-postgresql \
  --with-express-configuration \
  --region ap-northeast-1

while true; do
  RESULT=$(aws rds describe-db-clusters \
      --db-cluster-identifier my-express-db-2 \
      --region ap-northeast-1 \
      --query 'DBClusters[0].[Status,Endpoint]' \
      --output text)
  STATUS=$(echo "$RESULT" | awk '{print $1}')
  ENDPOINT=$(echo "$RESULT" | awk '{print $2}')
  ELAPSED=$(( $(date +%s) - START ))
  echo "$(date '+%H:%M:%S') [${ELAPSED}s] Status: ${STATUS}"
  if [ "$STATUS" = "available" ] && [ -n "$ENDPOINT" ]; then \
      TOKEN=$(aws rds generate-db-auth-token \
          --hostname "$ENDPOINT" \
          --port 5432 \
          --username postgres \
          --region ap-northeast-1 2>/dev/null)
      if PGPASSWORD="$TOKEN" psql \
          "host=$ENDPOINT port=5432 dbname=postgres user=postgres sslmode=require" \
          -c "SELECT 1" ; then \
          echo "$(date '+%H:%M:%S') [${ELAPSED}s] psql ログイン成功"
          break
      else \
          echo "$(date '+%H:%M:%S') [${ELAPSED}s] available（psql 接続確認中...）"
      fi
  fi
  sleep 1
done

$ ./rds_express.sh                                                                                                                    
開始: 06:36:21
{
    "DBCluster": {
        "AllocatedStorage": 1,
        "AvailabilityZones": [
            "ap-northeast-1c",
            "ap-northeast-1d",
            "ap-northeast-1a"
        ],
        "BackupRetentionPeriod": 1,
        "DBClusterIdentifier": "my-express-db-2",
        "DBClusterParameterGroup": "default.aurora-postgresql17",
        "Status": "creating",
        "MultiAZ": false,

06:36:29 [8s] Status: creating
06:36:31 [10s] Status: creating
06:36:33 [12s] Status: creating
06:36:35 [14s] Status: creating
06:36:37 [16s] Status: creating
06:36:39 [18s] Status: creating
06:36:41 [20s] Status: creating
06:36:43 [22s] Status: creating
06:36:45 [24s] Status: creating
06:36:47 [26s] Status: available
 ?column? 
----------
        1
(1 row)

06:37:00 [26s] psql ログイン成功

接続できたので、バージョンを確認します。

```bash
~ $ export RDSHOST="my-express-db-2.cluster-abcdefghijkl.ap-northeast-1.rds.amazonaws.com" 
~ $ psql "host=$RDSHOST port=5432 dbname=postgres user=postgres sslmode=require password=$(aws rds generate-db-auth-token --hostname $RDSHOST --port 5432 --username postgres --region ap-northeast-1)"
psql (15.16, server 17.7)
WARNING: psql major version 15, server major version 17.
         Some psql features might not work.
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

postgres=> SELECT version();
                                                   version                                                    
--------------------------------------------------------------------------------------------------------------
 PostgreSQL 17.7 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 10.5.0, 64-bit
(1 row)