Difference between revisions of "PostgreSQL"

From FusionPBX
Jump to: navigation, search
(Created page with "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 bac...")
 
(Backup)
Line 4: Line 4:
  
 
==Backup==
 
==Backup==
The following assumes the database username is fusionpbx and the database to backup is fusionpbx.
+
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 /usr/src/fusionpbx.sql
+
  pg_dump -U fusionpbx fusionpbx -f /tmp/fusionpbx.sql
  
 
==Restore==
 
==Restore==
  
 
==Additional Info==
 
==Additional Info==

Revision as of 02:32, 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