addCloudPostgresqlUserList

Available in VPC

Add a DB user to a Cloud DB for PostgreSQL instance.

Syntax

The addCloudPostgresqlUserList syntax is as follows:

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

Options

This section describes the options available when running addCloudPostgresqlUserList.

Required options

The following options are required for addCloudPostgresqlUserList.

Options	Type	Required	Description
`--cloudPostgresqlInstanceNo`	String	Required	Cloud DB for PostgreSQL instance number See getCloudPostgresqlInstanceList.
`--cloudPostgresqlUserList`	List	Required	List of DB users to add For each user, enter {field=‘value’} pairs within quotation marks, separated by commas. `name` (required): DB user account ID. Enter 4-16 characters using lowercase English letters, numbers, and special character `_`. The string must start with an English letter. Predefined roles and reserved words can't be used. `password` (required): 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` (required): 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` (required): Replication role status. `true` \| `false`

Common options

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

Examples

If the request to add a DB user is successful, the specified user will be added to the Cloud DB for PostgreSQL instance.

Command

The command example is as follows:

./ncloud vpostgresql addCloudPostgresqlUserList \
    --cloudPostgresqlInstanceNo 34567890 \
    --cloudPostgresqlUserList "name='testreader', password='Examplepw123!', clientCidr='0.0.0.0/0', isReplicationRole='false'" \
    --regionCode KR \
    --output json

Output

The output example is as follows:

{
  "addCloudPostgresqlUserListResponse": {
    "requestId": "a1b2c3d4-e5f6-7890-abcd-ef1234567890",
    "returnCode": "0",
    "returnMessage": "success"
  }
}