From 304f1b07d72ac7203399ad9b57734532cc927c2e Mon Sep 17 00:00:00 2001
From: vladfo <fvv2011@gmail.com>
Date: Wed, 17 Jul 2024 14:06:01 +0300
Subject: [PATCH] =?utf8?q?=D0=94=D0=BE=D0=B1=D0=B0=D0=B2=D0=BB=D0=B5=D0=BD?=
 =?utf8?q?=D0=B8=D0=B5=20=D0=B4=D0=BE=D0=BF=D0=BE=D0=BB=D0=BD=D0=B8=D1=82?=
 =?utf8?q?=D0=B5=D0=BB=D1=8C=D0=BD=D1=8B=D1=85=20=D0=B8=D0=BD=D1=81=D1=82?=
 =?utf8?q?=D1=80=D1=83=D0=BA=D1=86=D0=B8=D0=B9=20=D0=B2=20README.md?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 README.md | 34 ++++++++++++++++++++++++++++++++++
 1 file changed, 34 insertions(+)

diff --git a/README.md b/README.md
index f809697b..1c4cb57a 100644
--- a/README.md
+++ b/README.md
@@ -21,6 +21,40 @@ gzip -d -c pgsql_last.sql.gz | docker compose exec -T db-pgsql-yii_erp24 psql -U
 
 ```
 
+
+### Проблемы с БД после загрузки дампа
+
+При возникновении проблем с пользователем bazacvetov24
+
+```shell
+#Зайти в БД для выполнения запросов
+docker-compose exec db-pgsql-yii_erp24 psql -U root -d erp24
+
+GRANT USAGE ON SCHEMA public TO bazacvetov24;
+GRANT USAGE ON SCHEMA erp24 TO bazacvetov24;
+
+GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO bazacvetov24;
+GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA erp24 TO bazacvetov24;
+
+GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA public TO bazacvetov24;
+GRANT USAGE, SELECT ON ALL SEQUENCES IN SCHEMA erp24 TO bazacvetov24;
+
+ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO bazacvetov24;
+ALTER DEFAULT PRIVILEGES IN SCHEMA erp24 GRANT ALL ON TABLES TO bazacvetov24;
+ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON SEQUENCES TO bazacvetov24;
+ALTER DEFAULT PRIVILEGES IN SCHEMA erp24 GRANT ALL ON SEQUENCES TO bazacvetov24;
+```
+
+Добавить код в erp24/config/db.php
+
+```shell
+'on afterOpen' => function($event) {
+        $event->sender->createCommand("SET search_path TO public, erp24;")->execute(); },
+
+```
+
+
+
 ### Выкладка
 
 Перед выкладкой выполнить
-- 
2.39.5