This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
сервис_postgresql [2025/10/06 06:34] val [Kubernetes] |
сервис_postgresql [2025/10/28 08:35] (current) val [Клиент psql] |
||
|---|---|---|---|
| Line 125: | 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 131: | 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'; | ||