Difference between revisions of "PostgreSQL"
From FusionPBX
(→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/ | + | 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/