Backing up the OpenMFG database.
Command line examples (all platforms):
The following examples all use the user name "admin". This is the default name created when installing the PostBooks/OpenMFG software starting with version 3. Earlier versions used the user name "mfgadmin" as the default user and it is possible that the databases can be configured with a different name. You should use the appropriate privileged username in place of "admin" for your system.
If logged in to the server running Postgres as a user with the correct permissions, and Postgres runs on default port of 5432:
pg_dump -U admin databasename > backupname.sql
This will create a backup of databasename called backupname.sql
If Postgres is running on a port other than 5432:
pg_dump -U admin -p 5433 databasename > backupname.sql
If you are running pg_dump from a remote client:
pg_dump -U admin -h mypgserver.mydomain.com -p 5433 databasename > backupname.sql
See: RestoringTheDatabase