Differences

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

--- сервис_postgresql [2023/12/09 10:48]
val
+++ сервис_postgresql [2025/04/08 14:07] (current)
val [Подключение по сети]
@@ Line 1: / Line 1: @@
 ====== Сервис PostgreSQL ======
+  * [[https://selectel.ru/blog/courses/dive-into-postgresql/|Погружение в PostgreSQL (Selectel)]]
+===== Установка PostgreSQL =====
+==== Linux Debian/Ubuntu ====
+  * [[https://selectel.ru/blog/tutorials/how-to-install-and-use-postgresql-on-ubuntu-20-04/|Установка и использование PostgreSQL]]
+<code>
+server# apt install postgresql postgresql-contrib
+</code>
+==== Docker ====
   * [[https://habr.com/ru/articles/578744/|Запускаем PostgreSQL в Docker: от простого к сложному]]
-===== psql =====
+==== Kubernetes ====
+  * [[https://habr.com/ru/companies/oleg-bunin/articles/766898/|Операторы в Kubernetes]] и [[https://habr.com/ru/companies/flant/articles/684202/|Обзор операторов PostgreSQL для Kubernetes. Часть 3: CloudNativePG]]
+===== Клиент psql =====
   * [[https://stackoverflow.com/questions/70356736/postgres-lean-docker-image-containing-only-psql-client|Postgres lean Docker image containing only "psql" client]]
+  * [[https://www.postgresqltutorial.com/postgresql-administration/psql-commands/|17 Practical psql Commands That You Don’t Want To Miss]]
+<code>
+$ sudo -u postgres psql
+postgres=# ALTER USER postgres WITH PASSWORD 'strongpassword';
+postgres=# CREATE DATABASE keycloak;
+postgres=# \l
+postgres=# CREATE USER keycloak WITH PASSWORD 'strongpassword';
+postgres=# \dg
+postgres=# ALTER DATABASE keycloak OWNER TO keycloak;
+postgres=# \c keycloak
+keycloak=# \dt
+keycloak=# \d user_entity
+keycloak=# SELECT * FROM user_entity WHERE username='root';
+</code>
+===== Подключение по сети =====
+  * [[https://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection|Kill a postgresql session/connection]]
+  * Keycloak [[Сервис Keycloak#docker-compose]]
+<code>
+server# cat /etc/postgresql/15/main/postgresql.conf
+</code><code>
+...
+listen_addresses = '*'
+...
+</code><code>
+# cat /etc/postgresql/15/main/pg_hba.conf
+</code><code>
+...
+host    all             all             0.0.0.0/0            scram-sha-256
+...
+</code><code>
+server# systemctl restart postgresql
+client# apt install postgresql-client
+client$ psql postgres://postgres:strongpassword@IP_OR_DNS_NAME:5432/postgres
+</code>

Методические материалы Лохтурова Вячеслава

User Tools

Site Tools

Differences

Page Tools