pgo restore

pgo restore

Restore cluster

Synopsis

Restore the data of a PostgreSQL cluster from a backup

RBAC Requirements

Resources                                           Verbs
---------                                           -----
postgresclusters.postgres-operator.crunchydata.com  [get patch]
pgo restore CLUSTER_NAME [flags]

Examples

  # Restore the 'hippo' cluster using the latest backup and replay all available WAL
  pgo restore hippo --repoName repo1
  
  # Restore the 'hippo' cluster to a specific point in time
  pgo restore hippo --repoName repo1 --options '--type=time --target="2021-06-09 14:15:11-04"'

Options

  -h, --help                  help for restore
      --options stringArray   options to pass to the "pgbackrest restore" command; can be used multiple times
      --repoName string       repository to restore from

Options inherited from parent commands

      --as string                      Username to impersonate for the operation. User could be a regular user or a service account in a namespace.
      --as-group stringArray           Group to impersonate for the operation, this flag can be repeated to specify multiple groups.
      --as-uid string                  UID to impersonate for the operation.
      --cache-dir string               Default cache directory (default "$HOME/.kube/cache")
      --certificate-authority string   Path to a cert file for the certificate authority
      --client-certificate string      Path to a client certificate file for TLS
      --client-key string              Path to a client key file for TLS
      --cluster string                 The name of the kubeconfig cluster to use
      --context string                 The name of the kubeconfig context to use
      --insecure-skip-tls-verify       If true, the server's certificate will not be checked for validity. This will make your HTTPS connections insecure
      --kubeconfig string              Path to the kubeconfig file to use for CLI requests.
  -n, --namespace string               If present, the namespace scope for this CLI request
      --request-timeout string         The length of time to wait before giving up on a single server request. Non-zero values should contain a corresponding time unit (e.g. 1s, 2m, 3h). A value of zero means don't timeout requests. (default "0")
  -s, --server string                  The address and port of the Kubernetes API server
      --tls-server-name string         Server name to use for server certificate validation. If it is not provided, the hostname used to contact the server is used
      --token string                   Bearer token for authentication to the API server
      --user string                    The name of the kubeconfig user to use

SEE ALSO

  • pgo - pgo is a kubectl plugin for PGO, the open source Postgres Operator
  • pgo restore disable - Disable restores for a PostgresCluster