dev-npgsql/npgsql: Npgsql is the .NET data provider for PostgreSQL.

.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:266a96dac

#!/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