changeCloudPostgresqlUserList

Available in VPC

Edit the DB user's information registered in a Cloud DB for PostgreSQL instance.

Syntax

The changeCloudPostgresqlUserList syntax is as follows:

./ncloud vpostgresql changeCloudPostgresqlUserList \
    --cloudPostgresqlInstanceNo <instance-no> \
    --cloudPostgresqlUserList <user-config> \
    [--regionCode <KR|SGN|JPN>] \
    [--output <json|xml>]

Options

This section describes the options available when running changeCloudPostgresqlUserList.

Required options

The following options are required for changeCloudPostgresqlUserList.

Options	Type	Required	Description
`--cloudPostgresqlInstanceNo`	String	Required	Cloud DB for PostgreSQL instance number See getCloudPostgresqlInstanceList.
`--cloudPostgresqlUserList`	List	Required	List of DB users to be edited For each user, enter {field=‘value’} pairs within quotation marks, separated by commas. `name` (required): User ID. See getCloudPostgresqlUserList. `password` (conditional): DB user account password. Enter 8-20 characters containing at least one English letter, number, and special character. The special characters ` `&` `+` `\` `"` `'` `/` and spaces can't be used. User ID can't be included. `clientCidr` (conditional): CIDR range of clients allowed to connect to the server. Allow all: `0.0.0.0/0`, Specific IP: `192.168.1.1/32`, IP range: `192.168.1.0/24` `isReplicationRole` (conditional): Replication role status. `true` \| `false` One of the following is required: `password`, `clientCidr`, or `isReplicationRole`.

Common options

For information about the options common to all vpostgresql subcommands, see Cloud DB for PostgreSQL (VPC) options.

Examples

If the request to edit the DB user is successful, the information for the specified user will be updated.

Command

The command example is as follows:

./ncloud vpostgresql changeCloudPostgresqlUserList \
    --cloudPostgresqlInstanceNo 34567890 \
    --cloudPostgresqlUserList "name='testreader', isReplicationRole='true'" \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "changeCloudPostgresqlUserListResponse": {
    "requestId": "c3d4e5f6-a7b8-9012-cdef-345678901234",
    "returnCode": "0",
    "returnMessage": "success"
  }
}