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
+ # Disable access to MyPLC and drupal DBs from all hosts
sed -i -e '/^\(host\|local\)/d' $pghba_conf
# Enable passwordless localhost access
if [ -z "$PLC_DB_PASSWORD" ] ; then
PLC_DB_PASSWORD=$(uuidgen)
plc-config --category=plc_db --variable=password --value="$PLC_DB_PASSWORD" --save=$local_config $local_config
- service plc reload
+ #service plc reload
+ plc_reload force
fi
if ! psql -U $PLC_DB_USER -c "" template1 >/dev/null 2>&1 ; then
psql -U postgres -c "CREATE USER $PLC_DB_USER PASSWORD '$PLC_DB_PASSWORD'" template1