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;

Links
http://www.mkyong.com/database/backup-restore-database-in-postgresql-pg_dumppg_restore/

http://www.postgresql.org/docs/9.1/static/backup.html