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;