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
echo "timezone='UTC'" >> $postgresql_conf
######## /var/lib/pgsql/data/pg_hba.conf
- # Disable access to MyPLC and drupal DBs from all hosts
- sed -i -e '/^\(host\|local\)\s\($PLC_DB_NAME\|drupal\)/d' $pghba_conf
+ # Disable access to MyPLC and drupal DBs from all hosts
+ sed -i -e '/^\(host\|local\)/d' $pghba_conf
# Enable passwordless localhost access
echo "local all all trust" >>$pghba_conf
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