Difference between revisions of "PostgreSQL"
From FusionPBX
(→Backup) |
(→Backup) |
||
| Line 5: | Line 5: | ||
==Backup== | ==Backup== | ||
The following assumes the database username is fusionpbx and the database to backup is fusionpbx. Make sure you have the database password ready. | 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 | pg_dump -U fusionpbx fusionpbx -b -v -f /tmp/fusionpbx.sql | ||
Revision as of 03:00, 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.
su postgres pg_dump -U fusionpbx fusionpbx -b -v -f /tmp/fusionpbx.sql
Restore
Additional Info
http://www.mkyong.com/database/backup-restore-database-in-postgresql-pg_dumppg_restore/
