Difference between revisions of "PostgreSQL"

From FusionPBX
Jump to: navigation, search
(Additional Info)
(Additional Info)
Line 12: Line 12:
 
http://www.mkyong.com/database/backup-restore-database-in-postgresql-pg_dumppg_restore/
 
http://www.mkyong.com/database/backup-restore-database-in-postgresql-pg_dumppg_restore/
  
http://www.postgresql.org/docs/8.1/static/backup.html
+
http://www.postgresql.org/docs/9.1/static/backup.html

Revision as of 02:37, 28 October 2012

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.

pg_dump -U fusionpbx fusionpbx -f /tmp/fusionpbx.sql

Restore

Additional Info

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

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