# 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>