Aurora PostgreSQL restore from Snapshot with CLI

Question

Hi,

I am interested in using CLI's for our Aurora PostgreSQL. When using through Interface if I restore a snapshot it creates cluster & DB instance.I understand when using CLI's first I need to create cluster using RestoreDBClusterToPointInTime.How can I create instance with same settings from the snapshot using "CreateDBInstance".

I simply want to replicate all GUI steps of restoring from snapshot including the instance through CLI

Riku_Kobayashi · Answer

Hello.

The command is described in the documentation here.  
The command below is an example for Aurora MySQL, but I think it can be executed using similar steps for Aurora PostgreSQL.  
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html#Aurora.Managing.Clone.create  
```
aws rds restore-db-cluster-to-point-in-time \
  --source-db-cluster-identifier tpch100g \
  --db-cluster-identifier tpch100g-clone \
  --restore-type copy-on-write \
  --use-latest-restorable-time

aws rds describe-db-clusters \
  --db-cluster-identifier tpch100g-clone \
    --query '*[].[Engine]' \
    --output text

aws rds create-db-instance \
  --db-instance-identifier tpch100g-clone-instance \
  --db-cluster-identifier tpch100g-clone \
  --db-instance-class db.r5.4xlarge \
  --engine aurora-mysql

```

Aurora PostgreSQL restore from Snapshot with CLI

Relevant content