修复docker启动脚本

jingsam · jingsam · commit de70e8830c84 · 2025-05-25T15:21:16.000+08:00
diff --git a/migrations/db/init-scripts/00000000000003-post-setup.sql b/migrations/db/init-scripts/00000000000003-post-setup.sql
@@ -101,7 +101,7 @@ END
 $$;
 
 -- Supabase dashboard user
-CREATE ROLE dashboard_user NOSUPERUSER CREATEDB CREATEROLE REPLICATION;
+-- CREATE ROLE dashboard_user NOSUPERUSER CREATEDB CREATEROLE REPLICATION;
 -- GRANT ALL ON DATABASE postgres TO dashboard_user;
 GRANT ALL ON SCHEMA auth TO dashboard_user;
 GRANT ALL ON SCHEMA extensions TO dashboard_user;
diff --git a/migrations/db/migrate.sh b/migrations/db/migrate.sh
@@ -43,7 +43,7 @@ EOSQL
         echo "$0: running $sql"
         psql -v ON_ERROR_STOP=1 --no-password --no-psqlrc -U postgres -f "$sql"
     done
-    psql -v ON_ERROR_STOP=1 --no-password --no-psqlrc -U postgres -c "ALTER USER supabase_admin WITH PASSWORD '$PGPASSWORD'"
+    # psql -v ON_ERROR_STOP=1 --no-password --no-psqlrc -U postgres -c "ALTER USER supabase_admin WITH PASSWORD '$PGPASSWORD'"
     # run migrations as super user - postgres user demoted in post-setup
     for sql in "$db"/migrations/*.sql; do
         echo "$0: running $sql"
diff --git a/migrations/docker.sh b/migrations/docker.sh
@@ -32,16 +32,11 @@ done
 
 # 更改select version()返回值，以兼容GDAL
 docker exec -i hgdb gosu highgo bash <<- "EOF"
-  hg_version_gen "PostgreSQL 12.7" "PostgreSQL 12.7" "12.7"
-EOF
-
-# 临时关闭三权分立
-docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb psql -U syssso -d highgo <<- "EOF"
-  select set_secure_param('hg_sepv4','dyn_off');
+  hg_version_gen "PostgreSQL 12.7 (HGDB-SEE V4.5)" "瀚高安全版 V4.5" "12.7"
 EOF
 
 # 更改数据库配置
-docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb psql -U sysdba -d highgo <<- "EOF"
+docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb gosu highgo psql -U sysdba -d highgo <<- "EOF"
   alter system set shared_preload_libraries = pg_stat_statements, pg_cron, pg_net;
   alter system set wal_level = 'logical';
 EOF
@@ -58,8 +53,13 @@ until docker exec hgdb pg_isready -U sysdba -d highgo -q; do
   sleep 1
 done
 
+# 临时关闭三权分立
+docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb gosu highgo psql -U syssso -d highgo <<- "EOF"
+  select set_secure_param('hg_sepv4','dyn_off');
+EOF
+
 # 创建supabase所需的数据库和用户
-docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb psql -U sysdba -d highgo <<- EOF
+docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb gosu highgo psql -U sysdba -d highgo <<- EOF
   create role postgres superuser login password '$POSTGRES_PASSWORD';
   create role supabase_admin superuser login password '$POSTGRES_PASSWORD';
   create role dashboard_user NOSUPERUSER CREATEDB CREATEROLE REPLICATION;
@@ -72,6 +72,6 @@ EOF
 ./db/migrate.sh
 
 # 恢复三权分立
-docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb psql -U syssso -d highgo <<- "EOF"
+docker exec -i -e PGPASSWORD=$POSTGRES_PASSWORD hgdb gosu highgo psql -U syssso -d highgo <<- "EOF"
   select set_secure_param('hg_sepv4','on');
 EOF
