How do I backup my data?

Member for

1 month 3 weeks
Submitted by Anonymous (not verified) on Tue, 11/29/2011 - 19:44

As of 1.3.7 the backup functionality moved to setup.pl, the database administration interface.

Login with your ledgersmb database user / admin user. This can't be done using your normal LedgerSMB login account since it doesn't have enough rights to backup db and roles. The default address for setup.pl is http://localhost/ledgersmb/setup.pl.

The setup.pl backup facility consists of two parts:

  1. Backup of the data (parts, customers, accounting records, etc)
  2. Backup of the roles (your login accounts and rights)

The backup can be mailed to an e-mail account, or you can download it with your browser, depending on your output selection in the backup screen.

 

Note that alternative methods include the use of autopostgresqlbackup and PostgreSQL's command line utility pg_dump. See the Restore FAQ item for an example of the latter.

Release
FAQ Category
Topic

Member for

3 years 5 months

barryc

Thu, 07/04/2013 - 18:50

If I were to move my old 1.2 data to a new machine running 1.3, what else do I need to backup or pg_dump from the old machine so as to be able to restore into a new 1.3 setup?. Postgres 8.x does not have roles in the pg_dump and the FAQ mentions restoring the roles first.
How?