/
evcode
/
n8n-setup
Обзор
Документация
Войти
/
evcode
/
n8n-setup
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
postgres/init/01-init.sh
41 строка
1 KB
Evgeny Epifanov
change
14 фев 2026, 09:32
14 фев 2026, 09:32
afd249f
Код
Авторство
О чём код?
#!/bin/bash set -e install_postgis() { local db_name="$1" if [ -n "$db_name" ]; then psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname "$db_name" <<EXTSQL CREATE EXTENSION IF NOT EXISTS postgis; EXTSQL fi } psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" --dbname postgres <<EOSQL -- n8n DB $(if [ -n "${N8N_DB_NAME}" ] && [ -n "${N8N_DB_USER}" ] && [ -n "${N8N_DB_PASSWORD}" ]; then echo "CREATE USER \"${N8N_DB_USER}\" WITH PASSWORD '${N8N_DB_PASSWORD}' LOGIN;" echo "CREATE DATABASE \"${N8N_DB_NAME}\" OWNER \"${N8N_DB_USER}\";" fi) -- Custom DB $(if [ -n "${CUSTOM_DB_NAME}" ] && [ -n "${CUSTOM_DB_USER}" ] && [ -n "${CUSTOM_DB_PASSWORD}" ]; then echo "CREATE USER \"${CUSTOM_DB_USER}\" WITH PASSWORD '${CUSTOM_DB_PASSWORD}' LOGIN;" echo "CREATE DATABASE \"${CUSTOM_DB_NAME}\" OWNER \"${CUSTOM_DB_USER}\";" fi) -- Directus DB $(if [ -n "${DIRECTUS_DB_NAME}" ] && [ -n "${DIRECTUS_DB_USER}" ] && [ -n "${DIRECTUS_DB_PASSWORD}" ]; then echo "CREATE USER \"${DIRECTUS_DB_USER}\" WITH PASSWORD '${DIRECTUS_DB_PASSWORD}' LOGIN;" echo "CREATE DATABASE \"${DIRECTUS_DB_NAME}\" OWNER \"${DIRECTUS_DB_USER}\";" fi) -- NocoDB DB $(if [ -n "${NOCODB_DB_NAME}" ] && [ -n "${NOCODB_DB_USER}" ] && [ -n "${NOCODB_DB_PASSWORD}" ]; then echo "CREATE USER \"${NOCODB_DB_USER}\" WITH PASSWORD '${NOCODB_DB_PASSWORD}' LOGIN;" echo "CREATE DATABASE \"${NOCODB_DB_NAME}\" OWNER \"${NOCODB_DB_USER}\";" fi) EOSQL install_postgis "${DIRECTUS_DB_NAME}"