HA Active Active or Active Passive

Status
Not open for further replies.

Tiensicum

New Member
Sep 26, 2019
7
0
1
56
Vietnam
www.inext.com.vn
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
Sep 29, 2016
3,038
556
113
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
 

Tiensicum

New Member
Sep 26, 2019
7
0
1
56
Vietnam
www.inext.com.vn
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
 
Status
Not open for further replies.