How do I backup my data?

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: 

Comments

barryc's picture

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?

Barry Clearwater
BC Systems Consultancy