User Tools
сервис_postgresql
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
сервис_postgresql [2026/06/03 08:35] val [Kubernetes] |
сервис_postgresql [2026/06/11 11:11] (current) val [Kubernetes] |
||
|---|---|---|---|
| Line 63: | Line 63: | ||
| kube1:~# kubectl -n cnpg-system get all | kube1:~# kubectl -n cnpg-system get all | ||
| + | |||
| + | kube1:~# mkdir my-pgcluster; cd $_ | ||
| kube1:~/my-pgcluster# echo -n keycloak | base64 | kube1:~/my-pgcluster# echo -n keycloak | base64 | ||
| Line 122: | Line 124: | ||
| kube1:~# kubectl cnpg status my-pgcluster -n my-pgcluster-ns | kube1:~# kubectl cnpg status my-pgcluster -n my-pgcluster-ns | ||
| + | |||
| + | kube1:~# kubectl cnpg promote -n my-pgcluster-ns my-pgcluster my-pgcluster-1 | ||
| kube1:~# kubectl cnpg logs cluster my-pgcluster -n my-pgcluster-ns | kube1:~# kubectl cnpg logs cluster my-pgcluster -n my-pgcluster-ns | ||
| </code> | </code> | ||
| - | + | == Миграция с вышедшего из строя узла == | |
| - | == Перенос узла кластера на другой узел == | + | |
| <code> | <code> | ||
| - | kubeN:~# k -n my-pgcluster-ns delete pvc my-pgcluster-M | + | kube2:~# kubectl -n my-pgcluster-ns get pods |
| - | kubeN:~# k -n my-pgcluster-ns delete pod/my-pgcluster-M | + | ... |
| - | kubeN:~# kubectl -n my-pgcluster-ns get pods | + | my-pgcluster-3 0/1 Pending 0 80m |
| + | |||
| + | kube2# kubectl -n my-pgcluster-ns delete pvc my-pgcluster-3 | ||
| + | |||
| + | kube2# kubectl -n my-pgcluster-ns delete pods/my-pgcluster-3 | ||
| </code> | </code> | ||
| ===== Клиент psql ===== | ===== Клиент psql ===== | ||
| Line 208: | Line 215: | ||
| root@my-debian:~# psql postgres://keycloak:strongpassword@my-pgcluster-rw.my-pgcluster-ns:5432/keycloak -c "\dt" | root@my-debian:~# psql postgres://keycloak:strongpassword@my-pgcluster-rw.my-pgcluster-ns:5432/keycloak -c "\dt" | ||
| - | kube1:~/my-pgcluster# psql postgres://keycloak:strongpassword@10.233.13.120:5432/keycloak -c "\dt" | + | |
| + | kube1:~# host my-pgcluster-rw.my-pgcluster-ns.svc.cluster.local 169.254.25.10 | ||
| + | |||
| + | kube1:~# telnet 10.233.N.M 5432 | ||
| </code> | </code> | ||
сервис_postgresql.1780464951.txt.gz · Last modified: 2026/06/03 08:35 by val
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
