User Tools

Site Tools


сервис_postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
сервис_postgresql [2026/03/21 11:57]
val [Подключение по сети]
сервис_postgresql [2026/06/02 09:41] (current)
val [Kubernetes]
Line 118: Line 118:
  
 kube1:~# kubectl cnpg logs cluster my-pgcluster -n my-pgcluster-ns kube1:~# kubectl cnpg logs cluster my-pgcluster -n my-pgcluster-ns
 +</​code>​
 +
 +== Перенос узла кластера на другой узел ==
 +<​code>​
 +kubeN:~# k -n my-pgcluster-ns delete pvc my-pgcluster-M
 +kubeN:~# k -n my-pgcluster-ns delete pod/​my-pgcluster-M
 +kubeN:~# kubectl -n my-pgcluster-ns get pods
 </​code>​ </​code>​
 ===== Клиент psql ===== ===== Клиент psql =====
Line 192: Line 199:
 server# systemctl restart postgresql server# systemctl restart postgresql
  
-client$ psql postgres://​postgres:​strongpassword@IP_OR_DNS_NAME:​5432/​postgres ​#-c "​\dt"​+client$ psql postgres://​postgres:​strongpassword@IP_OR_DNS_NAME:​5432/​postgres
  
-root@my-debian:​~#​ psql postgres://​keycloak:​strongpassword@my-pgcluster-rw.my-pgcluster-ns:​5432/​keycloak+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"​
 </​code>​ </​code>​
  
сервис_postgresql.1774083452.txt.gz · Last modified: 2026/03/21 11:57 by val