Available in VPC
View Cloud DB for PostgreSQL database server log list.
Commands
The text of the command is as follows:
ncloud vpostgresql getDbServerLogList [regionCode] [logType] [cloudPostgresqlServerInstanceNo] [pageNo] [pageSize] [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 |
- |
| logType | String | Y | Database server log file type - options: POSTGRESQL_LOG |
- |
| cloudPostgresqlServerInstanceNo | String | Y | Cloud DB for PostgreSQL server instance number - You can obtain cloudPostgresqlServerInstanceNo through the getCloudPostgresqlInstanceList action |
- |
| pageNo | Integer | N | Page number of paged results - The results can be paged using pageNo and pageSize |
- Min: 0 |
| pageSize | Integer | N | Size of each page to be shown during paging - The results can be paged using pageNo and pageSize - Enter it every time you enter pageNo |
- Min: 1 - Max: 1000 |
| output | String | N | Format type of the response result - options: xml | json - default: json |
- |
Responses
Response data type
- CloudPostgresqlDbServerLogList type
| CloudPostgresqlDbServerLogList extends CommonResponse | Description |
|---|---|
| private Integer totalRows; | Total number of items viewed |
| private List<CloudPostgresqlDbServerLog> cloudPostgresqlDbServerLogList = new ArrayList<>(); | Cloud DB for PostgreSQL database server log list |
- CloudPostgresqlDbServerLog type
| CloudPostgresqlDbServerLog | Description |
|---|---|
| private String fileName; | Database server log file name |
| private Long fileSize; | Database server log file size |
| private Date fileDate; | Date and time when database server log file was edited |
Examples
Describes examples of recalls and responses.
Recall examples
The following are examples of recalls.
ncloud vpostgresql getDbServerLogList --regionCode KR --logType POSTGRESQL_LOG --cloudPostgresqlServerInstanceNo ****891
Response examples
The following are examples of responses.
If the response shows that format type (output) is json
{
"getDbServerLogListResponse": {
"requestId": "d733e677-ad69-4cbe-8351-711d0e0124bc",
"returnCode": "0",
"returnMessage": "success",
"totalRows": "1",
"cloudPostgresqlDbServerLogList": {
"cloudPostgresqlDbServerLog": {
"fileName": "postgresql_000000.log",
"fileSize": "194",
"fileDate": "2021-05-27T18:10:00+0900"
}
}
}
}
If the response shows that format type (output) is xml
<getDbServerLogListResponse>
<requestId>d733e677-ad69-4cbe-8351-711d0e0124bc</requestId>
<returnCode>0</returnCode>
<returnMessage>success</returnMessage>
<totalRows>1</totalRows>
<cloudPostgresqlDbServerLogList>
<cloudPostgresqlDbServerLog>
<fileName>postgresql_000000.log</fileName>
<fileSize>194</fileSize>
<fileDate>2021-05-27T18:10:00+0900</fileDate>
</cloudPostgresqlDbServerLog>
</cloudPostgresqlDbServerLogList>
</getDbServerLogListResponse>