HA Active Active or Active Passive

It doesn't need those roles.
But in file "postgresql.sh" have two lines require superuser role:
sudo -u postgres psql -h $database_host -c "CREATE ROLE fusionpbx WITH SUPERUSER LOGIN PASSWORD '$password';"
sudo -u postgres psql -h $database_host -c "CREATE ROLE freeswitch WITH SUPERUSER LOGIN PASSWORD '$password';"
Last edited: A moment ago
 

DigitalDaz

Administrator
Staff member
Install fusionpbx as normal then:

Code:
su - postgres
pg_dump fusionpbx > /tmp/fusionpbx.sql
exit
You now have your dump in /tmp. Create your DB on google then something along the lines of:

Code:
psql -h X.X.X.X -Ufusionpbx fusionpbx < /tmp/fusionpbx.sql
Then update the config files in FusionPBX to point to the new DBs
 
Hello @DigitalDaz ,
I did try:
root@pbx01:/usr/src/fusionpbx-install-22-10-2019.sh/debian# psql -h 10.26.0.3 -U fusionpbx fusionpbx < /tmp/fusionpbx.sql
Password for user fusionpbx:
psql: FATAL: password authentication failed for user "fusionpbx"
FATAL: password authentication failed for user "fusionpbx"

I think on GCloud DB doesn't have user fusionpbx. I missing something, please help me.
Thanks