PostgreSQL

PostgreSQL is a enterprise grade open source database. http://www.postgresql.org/

Backup

The following assumes the database username is fusionpbx and the database to backup is fusionpbx. Make sure you have the database password ready.

su postgres
pg_dump -U fusionpbx fusionpbx -b -v -f /tmp/fusionpbx.sql

Restore

Assuming username fusionpbx and database fusionpbx

psql -U fusionpbx -d fusionpbx -f fusionpbx.sql

Console

su postgres
psql

list the databases

\l

connect to the database

\connect fusionpbx

or

\c fusionpbx

list tables

\d

drop the database

DROP DATABASE fusionpbx;

create the database

CREATE DATABASE fusionpbx;