addCloudPostgresqlUserList

Prev Next

Available in VPC

Add DB user to Cloud DB for PostgreSQL.

Commands

The text of the command is as follows:

ncloud vpostgresql addCloudPostgresqlUserList [regionCode] [cloudPostgresqlInstanceNo] [cloudPostgresqlUserList] [output]

Parameter

The following is a description on parameters.

Parameter Type Requirement status Description Restrictions
regionCode String N Region code
- regionCode can be obtained via the getRegionList action
- Default: selects the first region of the getRegionList search results		 -
cloudPostgresqlInstanceNo String Y Cloud DB for PostgreSQL instance number
- cloudPostgresqlInstanceNo can be obtained via the getCloudPostgresqlInstanceList action		 -
cloudPostgresqlUserList.N.name List<String> Y Cloud DB for PostgreSQL DB User ID
- Up to 10 user tasks can be performed at a time		 - Only English lowercase letters, numbers, and underscore characters ( _ ) are allowed, and must start with an English letter
- Predefined roles and reserved words cannot be used
- Min: 4
- Max: 16
cloudPostgresqlUserList.N.clientCidr List<String> Y Client CIDR of Cloud DB for PostgreSQL DB User
Example)
- Allow access to all: 0.0.0.0/0
- Allow specific IP access: 192.168.1.1/32
- Allow IP range access: 192.168.1.0/24		 -
cloudPostgresqlUserList.N.password List<String> Y Cloud DB for PostgreSQL DB User password - Must contain at least 1 each of English letter, number, and special character
- The following characters cannot be used in the password: ` & + \ " ' / and space
- Cannot include user ID
- Min: 8
- Max: 20
cloudPostgresqlUserList.N.isReplicationRole List<Boolean> Y Replication role status -
output String N Format type of the response result
- options: xml | json
- default: json		 -

Examples

Describes examples of recalls and responses.

Recall examples

The following are examples of recalls.

ncloud vpostgresql addCloudPostgresqlUserList --regionCode KR --cloudPostgresqlInstanceNo ****890 --cloudPostgresqlUserList "name='pgtest', clientCidr='0.0.0.0/0', password='********', isReplicationRole='false'"

Response examples

The following are examples of responses.

If the response shows that format type (output) is json

{
  "addCloudPostgresqlUserListResponse": {
    "requestId": "d35c01cf-e77a-44a9-a2b9-1fd1f9572750",
    "returnCode": 0,
    "returnMessage": "success"
  }
}

If the response shows that format type (output) is xml

<addCloudPostgresqlUserListResponse>
  <requestId>d35c01cf-e77a-44a9-a2b9-1fd1f9572750</requestId>
  <returnCode>0</returnCode>
  <returnMessage>success</returnMessage>
</addCloudPostgresqlUserListResponse>