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

.devcontainer/db/init-db.sh

25 строк1 KB

Yoh Deadfall

Add binary protocol support for label tree (ltree)

10 ноя 2020, 16:06

10 ноя 2020, 16:06ed2f47d

#!/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
psql -U postgres -c "CREATE USER npgsql_tests SUPERUSER PASSWORD 'npgsql_tests'"
psql -U postgres -c "CREATE DATABASE npgsql_tests OWNER npgsql_tests"
psql -U postgres -c "CREATE EXTENSION ltree" npgsql_tests