update

Update a user's password

Usage

ionosctl dbaas postgres user update [flags]

Aliases

For postgres command:

[pg pgsql postgresql psql]

For user command:

[usr u users]

Description

Change the login password of an existing user in the given cluster.

Only the password can be changed; a user cannot be renamed. System users (System=true) are managed by the service and cannot be patched.

Required values to run command:

• Cluster Id

• User (name)

• Password (the new password)

Options

  -u, --api-url string      Override default host URL. Preferred over the config file override 'psql' and env var 'IONOS_API_URL' (default "https://api.ionos.com/databases/postgresql")
  -i, --cluster-id string   ID of the PostgreSQL cluster the user belongs to
      --cols strings        Set of columns to be printed on output 
                            Available columns: [Id Username System ClusterId]
  -c, --config string       Configuration file used for authentication (default "$XDG_CONFIG_HOME/ionosctl/config.yaml")
  -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)
      --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")
  -p, --password string     New login password for the user. Minimum 10 characters
      --query string        JMESPath query string to filter the output
  -q, --quiet               Quiet output
  -t, --timeout int         Timeout in seconds for --wait and other wait operations (default 600)
      --user string         Name of the existing (non-system) user whose password is changed
  -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 user update --cluster-id CLUSTER_ID --user appuser --password 'N3wS3cr3tPass'