Backup restore

[Aashish sharma]

Hello,
How to restore backup in fusionpbx.
Any commands or something else.
Please let me know.

 

[ad5ou]

https://docs.fusionpbx.com/en/latest/getting_started/restore.html is official public documentation but makes a few assumptions of where backup is coming from.

The important part is to have a working fresh install then extract backup files in place of default install then restore database

tar -xvpzf /var/backups/fusionpbx/backup_filename.tgz -C /

remove the old database
psql --host=$database_host --port=$database_port  --username=fusionpbx -c 'drop schema public cascade;'
psql --host=$database_host --port=$database_port  --username=fusionpbx -c 'create schema public;'
#restore the database
pg_restore -v -Fc --host=$database_host --port=$database_port --dbname=fusionpbx --username=fusionpbx /var/backups/fusionpbx/postgresql/fusionpbx_pgsql_$now.sql

#restart freeswitch
service freeswitch restart

The pg_restore command above needs proper database host/port and file name of the database backup to work.

 

[jonbanega]

https://docs.fusionpbx.com/en/latest/getting_started/restore.html is official public documentation but makes a few assumptions of where backup is coming from.

The important part is to have a working fresh install then extract backup files in place of default install then restore database

tar -xvpzf /var/backups/fusionpbx/backup_filename.tgz -C /

remove the old database
psql --host=$database_host --port=$database_port  --username=fusionpbx -c 'drop schema public cascade;'
psql --host=$database_host --port=$database_port  --username=fusionpbx -c 'create schema public;'
#restore the database
pg_restore -v -Fc --host=$database_host --port=$database_port --dbname=fusionpbx --username=fusionpbx /var/backups/fusionpbx/postgresql/fusionpbx_pgsql_$now.sql

#restart freeswitch
service freeswitch restart

The pg_restore command above needs proper database host/port and file name of the database backup to work.

psql: error: FATAL: Peer authentication failed for user "fusionpbx" getting this error can you help

 

[ad5ou]

You need the database password.
Depending on how the fresh install was done, you may need to reset it to match the old password, or make a few changes after the restore.

The database password can be fount in /etc/fusionpbx/config.php on a working setup. If installed without customizations from install script, the database password will be random for each installation.

grep db_password /etc/fusionpbx/config.php | cut -d "'" -f2

will help you find the expected database password.

 

[NVGcom]

Hi,

The file now is config.conf so the Documentation is outdated.
Just do

cat /etc/fusionpbx/config.conf | grep password