PGDATA=/var/lib/pgsql/data
postgresql_conf=$PGDATA/postgresql.conf
pghba_conf=$PGDATA/pg_hba.conf
-postgresql_sysconfig=/etc/sysconfig/pgsql
+postgresql_sysconfig=/etc/sysconfig/pgsql/postgresql
# Export so that we do not have to specify -p to psql invocations
export PGPORT=$PLC_DB_PORT
MESSAGE=$"Starting PostgreSQL server"
dialog "$MESSAGE"
- ######## sysconfig
+ ######## sysconfig
+# xxx on f16, the systemd init script won't read /etc/sysconfig/pgsql/postgresql any more
+# need to find out how to perform this configuration, if still needed
# Set data directory and redirect startup output to /var/log/pgsql
mkdir -p $(dirname $postgresql_sysconfig)
touch $postgresql_sysconfig
# PostgreSQL must be started at least once to bootstrap
# /var/lib/pgsql/data
if [ ! -f $postgresql_conf ] ; then
- service postgresql initdb &> /dev/null || :
- check
+# fedora 16 uses systemd
+# http://docs.fedoraproject.org/en-US/Fedora/16/html/Release_Notes/sect-Release_Notes-Changes_for_Sysadmin.html
+ if type postgresql-setup >& /dev/null ; then
+ postgresql-setup initdb || :
+ check
+ else
+ service postgresql initdb &> /dev/null || postgresql :
+ check
+ fi
fi
######## /var/lib/pgsql/data/postgresql.conf
echo "timezone='UTC'" >> $postgresql_conf
######## /var/lib/pgsql/data/pg_hba.conf
- # Disable access to all DBs from all hosts
- sed -i -e '/^\(host\|local\)/d' $pghba_conf
+ # Disable access to MyPLC and drupal DBs from all hosts
+ sed -i -e '/^\(host\|local\)\s\($PLC_DB_NAME\|drupal\)/d' $pghba_conf
# Enable passwordless localhost access
echo "local all all trust" >>$pghba_conf