forked from norman/fusionpbx-install.sh-github-mirror
309dd5fdbd
Reason for this change is if FreeSWITCH uses the PostgreSQL then its a good idea for it to use its own instance. This is to prevent blocking FreeSWITCH from accessing the database if there is a long running Query on the FusionPBX database
28 lines
766 B
Bash
Executable File
28 lines
766 B
Bash
Executable File
#!/bin/sh
|
|
|
|
#move to script directory so all relative paths work
|
|
cd "$(dirname "$0")"
|
|
|
|
#includes
|
|
. ../config.sh
|
|
|
|
#set the working directory
|
|
cwd=$(pwd)
|
|
cd /tmp
|
|
|
|
#set client encoding
|
|
sudo -u postgres psql -p $database_port -c "SET client_encoding = 'UTF8';";
|
|
|
|
#add the database users and databases
|
|
sudo -u postgres psql -p $database_port -c "CREATE DATABASE fusionpbx;";
|
|
|
|
#add the users and grant permissions
|
|
sudo -u postgres psql -p $database_port -c "CREATE ROLE fusionpbx WITH SUPERUSER LOGIN PASSWORD '$database_password';"
|
|
sudo -u postgres psql -p $database_port -c "GRANT ALL PRIVILEGES ON DATABASE fusionpbx to fusionpbx;"
|
|
|
|
#reload the config
|
|
sudo -u postgres psql -p $database_port -c "SELECT pg_reload_conf();"
|
|
|
|
#restart postgres
|
|
#systemctl restart postgresql
|