$NetBSD: patch-aa,v 1.4 2019/11/03 14:05:19 triaxx Exp $ Set pkgsrc AWLDIR. --- dba/create-database.sh.orig 2019-01-30 21:53:08.000000000 +0000 +++ dba/create-database.sh @@ -12,7 +12,7 @@ INSTALL_NOTE_FN="`mktemp -t tmp.XXXXXXXX # Candidate locations of the AWL directory -awldirs="${DBADIR}/../../awl +awldirs="@LIBAWLPATH@ /usr/share/awl /usr/share/php/awl /usr/local/share/awl" @@ -41,19 +41,19 @@ AWL_APPUSER="${4:-davical_app}" # set -x # Get the major version for PostgreSQL -export DBVERSION="`psql -qXAt ${PSQLOPTS} -c "SELECT version();" template1 | cut -f2 -d' ' | cut -f1-2 -d'.'`" +export DBVERSION="`psql -U @PGUSER@ -qXAt ${PSQLOPTS} -c "SELECT version();" template1 | cut -f2 -d' ' | cut -f1-2 -d'.'`" install_note() { cat >>"${INSTALL_NOTE_FN}" } db_users() { - psql -qXAt ${PSQLOPTS} -c "SELECT usename FROM pg_user;" template1 + psql -U @PGUSER@ -qXAt ${PSQLOPTS} -c "SELECT usename FROM pg_user;" template1 } create_db_user() { if ! db_users | grep "^${1}$" >/dev/null ; then - psql -qXAt ${PSQLOPTS} -c "CREATE USER ${1} NOCREATEDB NOCREATEROLE;" template1 + psql -U @PGUSER@ -qXAt ${PSQLOPTS} -c "CREATE USER ${1} NOCREATEDB NOCREATEROLE;" template1 cat <