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/05 18:33] val [Kubernetes] |
сервис_postgresql [2025/10/28 08:35] (current) val [Клиент psql] |
||
|---|---|---|---|
| Line 56: | Line 56: | ||
| * [[https://habr.com/ru/companies/oleg-bunin/articles/766898/|Операторы в Kubernetes]] и [[https://habr.com/ru/companies/flant/articles/684202/|Обзор операторов PostgreSQL для Kubernetes. Часть 3: CloudNativePG]] | * [[https://habr.com/ru/companies/oleg-bunin/articles/766898/|Операторы в Kubernetes]] и [[https://habr.com/ru/companies/flant/articles/684202/|Обзор операторов PostgreSQL для Kubernetes. Часть 3: CloudNativePG]] | ||
| - | * [[Система Kubernetes#rancher local-path-provisioner]] | + | * Dynamic Volume Provisioning [[Система Kubernetes#rancher local-path-provisioner]] |
| <code> | <code> | ||
| Line 92: | Line 92: | ||
| storage: | storage: | ||
| size: 10Gi | size: 10Gi | ||
| + | # storageClass: local-path | ||
| </code><code> | </code><code> | ||
| kube1:~/my-pgcluster# kubectl create ns my-pgcluster-ns | kube1:~/my-pgcluster# kubectl create ns my-pgcluster-ns | ||
| Line 124: | Line 125: | ||
| # sudo -u postgres psql | # sudo -u postgres psql | ||
| + | |||
| + | postgres=# SELECT version(); | ||
| postgres=# ALTER USER postgres WITH PASSWORD 'strongpassword'; | postgres=# ALTER USER postgres WITH PASSWORD 'strongpassword'; | ||
| Line 130: | Line 133: | ||
| 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.1759678390.txt.gz · Last modified: 2025/10/05 18:33 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
