Getting information on existing PostgreSQL clusters
You can request detailed information about each Managed Service for PostgreSQL cluster you created.
Getting a list of database clusters in a folder
Go to the folder page and select Managed Service for PostgreSQL.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To request a list of PostgreSQL clusters in the default folder, run the command:
yc managed-postgresql cluster list
+----------------------+---------------+-----------------------------+--------+---------+
| ID | NAME | CREATED AT | HEALTH | STATUS |
+----------------------+---------------+-----------------------------+--------+---------+
| c9wlk4v14uq7******** | mypg | 2018-11-02T10:04:14.645214Z | ALIVE | RUNNING |
| ... |
+----------------------+---------------+-----------------------------+--------+---------+
To get a list of DB clusters in a folder, use the list REST API method for the Cluster resource or the ClusterService/List gRPC API call and provide the folder ID in the folderId
request parameter.
Getting detailed information about a cluster
- Go to the folder page and select Managed Service for PostgreSQL.
- Click the cluster name.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To get information about a PostgreSQL cluster, run the following command:
yc managed-postgresql cluster get <cluster_name_or_ID>
You can request the cluster ID and name with a list of clusters in the folder.
To get cluster details, use the get REST API method for the Cluster resource or the ClusterService/Get gRPC API call and provide the cluster ID in the clusterId
request parameter.
You can get the cluster ID with a list of clusters in the folder.
Viewing a list of operations in a cluster
The operation list shows the operations performed with clusters and related resources (databases, shards, users, and backup copies).
- Go to the folder page and select Managed Service for PostgreSQL.
- Click the cluster name.
- Go to the Operations tab.
If you do not have the Yandex Cloud command line interface yet, install and initialize it.
The folder specified in the CLI profile is used by default. You can specify a different folder using the --folder-name
or --folder-id
parameter.
To get a list of operations, run the following command:
yc managed-postgresql cluster list-operations <cluster_name_or_ID>
You can request the cluster ID and name with a list of clusters in the folder.
To get a list of cluster operations, use the listOperations REST API method for the Cluster resource or the ClusterService/ListOperations gRPC API call and provide the cluster ID in the clusterId
request parameter.
You can get the cluster ID with a list of clusters in the folder.