Index: openacs-4/etc/install/install.sh =================================================================== RCS file: /usr/local/cvsroot/openacs-4/etc/install/install.sh,v diff -u -r1.24 -r1.25 --- openacs-4/etc/install/install.sh 4 Nov 2003 15:36:17 -0000 1.24 +++ openacs-4/etc/install/install.sh 5 Nov 2003 11:20:50 -0000 1.25 @@ -218,14 +218,29 @@ exit fi -# Recreate the database user -echo "$0: Recreating database user at $(date)" +# Recreate the database user and database +echo "$0: Recreating database user and database at $(date)" if [ $database == "postgres" ]; then # Postgres pg_bindir=`get_config_param pg_bindir` pg_port=`get_config_param pg_port` db_name=`get_config_param db_name` - su `get_config_param pg_db_user` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/dropdb -p $pg_port $db_name; ${pg_bindir}/createdb -p $pg_port $db_name;"; + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/dropuser -\ +p $pg_port $db_name" + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/createuser\ + -d -a -p $pg_port $db_name" + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/dropdb -p \ +$pg_port $db_name" + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/createdb -\ +p $pg_port $db_name" + + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/createuser \ +-d -a -p $pg_port $db_name" + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/dropdb -p $\ +pg_port $db_name" + su `get_config_param pg_db_admin` -c "export LD_LIBRARY_PATH=${pg_bindir}/../lib; ${pg_bindir}/createdb -p\ + $pg_port $db_name" + # createlang was part of this command but is not necessary (and causes an error) for # newer installs # ${pg_bindir}/createlang -p $pg_port plpgsql $db_name";