/
dev-npgsql
/
npgsql
Обзор
Документация
Войти
/
dev-npgsql
/
npgsql
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
.devcontainer/db/init-db.sh
28 строк
1 KB
Calvin Spring
Bump devcontainer dotnet SDK and add PostGIS (#5416)
19 ноя 2023, 23:26
Не верифицирован
19 ноя 2023, 23:26
6a96dac
Код
Авторство
О чём код?
#!/bin/sh set -e # Generate server certificate echo "Generating $PGDATA/server.crt and $PGDATA/server.key" openssl req -new -x509 -days 365 -nodes -text -out $PGDATA/server.crt -keyout $PGDATA/server.key -subj '/C=US' chmod 0600 $PGDATA/server.key chown postgres $PGDATA/server.key # Configure PostgreSQL echo "Setting 'ssl = on' in $PGDATA/postgresql.conf" sed -i 's/#ssl = off/ssl = on/' $PGDATA/postgresql.conf echo "Setting 'max_prepared_transactions = 10' in $PGDATA/postgresql.conf" sed -i 's/#max_prepared_transactions = 0/max_prepared_transactions = 10/' $PGDATA/postgresql.conf echo "Configuring md5 authentication in $PGDATA/pg_hba.conf" # Disable trust authentication, requiring MD5 passwords - some tests must fail if a password isn't provided. echo 'local all all trust' > $PGDATA/pg_hba.conf echo "host all all all md5" >> $PGDATA/pg_hba.conf # Standard test account for Npgsql and enable extensions psql -U postgres <<EOF CREATE USER npgsql_tests SUPERUSER PASSWORD 'npgsql_tests'; CREATE DATABASE npgsql_tests OWNER npgsql_tests; CREATE EXTENSION ltree npgsql_tests; CREATE EXTENSION postgis npgsql_tests; EOF