restore

Restore a PostgreSQL Cluster

Usage

ionosctl dbaas postgres-v2 cluster restore [flags]

Aliases

For postgres-v2 command:

[pg-v2 pgsql-v2 postgresql-v2 psql-v2]

For cluster command:

[c]

For restore command:

[r]

Description

Use this command to trigger an in-place restore of the specified PostgreSQL Cluster.

The restore uses the cluster's existing backups automatically; no source backup can be specified. The current data is overwritten with the restored data, and the cluster may experience a brief period of downtime during this process.

Required values to run command:

• Cluster Id
• Recovery Time
• DB Password

Options

  -u, --api-url string         Override default host URL. If contains placeholder, location will be embedded. Preferred over the config file override 'psqlv2' and env var 'IONOS_API_URL' (default "https://postgresql.%s.ionos.com")
  -i, --cluster-id string      The unique ID of the Cluster (required)
      --cols strings           Set of columns to be printed on output 
                               Available columns: [ClusterId DisplayName DnsName PostgresVersion Instances Ram Cores StorageSize State SyncMode Description ConnectionPooler MaintenanceDay MaintenanceTime BackupLocation BackupRetentionDays LogsEnabled MetricsEnabled DatacenterId LanId Cidr DbUsername DbDatabase StatusMessage]
  -c, --config string          Configuration file used for authentication (default "$XDG_CONFIG_HOME/ionosctl/config.yaml")
  -P, --db-password string     Password for the initial postgres user (required)
  -D, --depth int              Level of detail for response objects (default 1)
  -F, --filters strings        Limit results to results containing the specified filter:KEY1=VALUE1,KEY2=VALUE2
  -f, --force                  Force command to execute without user input
  -h, --help                   Print usage
      --limit int              Maximum number of items to return per request (default 50)
  -l, --location string        Location of the resource to operate on. When unset, list commands query all locations. Can be one of: de/txl, de/fra, es/vit, fr/par, gb/lhr, gb/bhx, us/las, us/mci, us/ewr
      --no-headers             Don't print table headers when table output is used
      --offset int             Number of items to skip before starting to collect the results
      --order-by string        Property to order the results by
  -o, --output string          Desired output format [text|json|api-json] (default "text")
      --query string           JMESPath query string to filter the output
  -q, --quiet                  Quiet output
  -R, --recovery-time string   ISO 8601 timestamp up to which the cluster is restored using its existing backups (required)
  -t, --timeout int            Timeout in seconds for --wait and other wait operations (default 600)
  -v, --verbose count          Increase verbosity level [-v, -vv, -vvv]
  -w, --wait                   Wait for the resource to reach AVAILABLE state after the command completes. No-op for list commands

Examples

ionosctl dbaas postgres-v2 cluster restore --cluster-id <cluster-id> --recovery-time <RFC3339-timestamp> --db-password <password>