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

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

Contenuto pertinente