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 [2025/10/28 07:40] val [Клиент psql] |
сервис_postgresql [2026/02/20 13:56] (current) val [Kubernetes] |
||
|---|---|---|---|
| Line 28: | Line 28: | ||
| * Dynamic Volume Provisioning [[Система Kubernetes#longhorn]] | * Dynamic Volume Provisioning [[Система Kubernetes#longhorn]] | ||
| + | * !!! Поменять repository и allowInsecureImages по аналогии Keycloak в [[Сервис Keycloak#Kubernetes]] | ||
| <code> | <code> | ||
| kube1:~/my-postgres# helm show values oci://registry-1.docker.io/bitnamicharts/postgresql --version 16.6.2 | tee values.yaml.orig | kube1:~/my-postgres# helm show values oci://registry-1.docker.io/bitnamicharts/postgresql --version 16.6.2 | tee values.yaml.orig | ||
| Line 95: | Line 96: | ||
| </code><code> | </code><code> | ||
| kube1:~/my-pgcluster# kubectl create ns my-pgcluster-ns | kube1:~/my-pgcluster# kubectl create ns my-pgcluster-ns | ||
| + | </code> | ||
| + | * [[Система Kubernetes#Kustomize]] | ||
| + | <code> | ||
| kube1:~/my-pgcluster# kubectl -n my-pgcluster-ns apply -f keycloak-db-secret.yaml,my-pgcluster.yaml | kube1:~/my-pgcluster# kubectl -n my-pgcluster-ns apply -f keycloak-db-secret.yaml,my-pgcluster.yaml | ||
| kube1# watch kubectl -n my-pgcluster-ns get all | kube1# watch kubectl -n my-pgcluster-ns get all | ||
| - | kube1# ###kubectl -n my-pgcluster-ns exec -it pod/my-pgcluster-1 -- psql | + | kube1# kubectl -n my-pgcluster-ns exec -it pod/my-pgcluster-1 -- psql |
| kube1# ###psql postgres://keycloak:strongpassword@my-pgcluster-rw.my-pgcluster-ns:5432/keycloak | kube1# ###psql postgres://keycloak:strongpassword@my-pgcluster-rw.my-pgcluster-ns:5432/keycloak | ||
| Line 133: | Line 136: | ||
| postgres=# \l | postgres=# \l | ||
| + | postgres=> SELECT datname FROM pg_database; | ||
| postgres=# CREATE USER keycloak WITH PASSWORD 'strongpassword'; | postgres=# CREATE USER keycloak WITH PASSWORD 'strongpassword'; | ||
сервис_postgresql.1761626425.txt.gz · Last modified: 2025/10/28 07:40 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
