1.5

How do I restore my data?

Submitted by ehu on Mon, 05/13/2013 - 13:04

Assuming you have followed the How Do I Backup My Data instructions, you can restore your database as follows...

1) Restore the roles

$ psql -h [database host] -U [database admin user] < [roles backup file]

For example:

$ psql -h localhost -U lsmb_dbadmin < lsmb-roles.sqlc

2) Create a new database to restore into

$ psql -h [database host] -U [database admin user] -c 'CREATE DATABASE [new company name]'

For example:

How do I backup my data?

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

Log in to the the 'setup.pl' administrative interface, using your ledgersmb database admin user (usually "lsmb_dbadmin" or "postgres"). The default address for setup.pl is http://localhost/ledgersmb/setup.pl.

There are 2 buttons:

  • Backup database (parts, customers, accounting records, etc)
  • Backup roles (your login accounts and rights)

One creates a backup of the content of your database. The other creates a backup of the roles.

1.5.30 Released

Submitted by LedgerSMB_Team on Fri, 11/29/2019 - 02:26

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:

Changelog for 1.5.30

1.5.29 Released

Submitted by LedgerSMB_Team on Fri, 11/15/2019 - 10:44

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:

Changelog for 1.5.29

  • Fix occasional COGS error on invoice posting (Erik H)
  • Fix occasional COGS error on invoice reversal posting (Erik H)
  • Fix failure on first reconciliation report for an account (Erik H)

Erik H is Erik Huelsmann

1.5.28 Released

Submitted by LedgerSMB_Team on Sat, 11/02/2019 - 08:25

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:

Changelog for 1.5.28

  • Fix invoice screens crashing on manual tax with 0% tax rate (Erik H)
  • Fix manual tax lines posted on current instead of transaction date (Erik H)
  • Fix SQL error in reversal of services in AP invoice (Erik H)

Erik H is Erik Huelsmann

1.5.27 Released

Submitted by LedgerSMB_Team on Fri, 10/18/2019 - 04:50

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:

Changelog for 1.5.27

  • Fix incorrect tax checkmarks in contact screen after save (Erik H)

Erik H is Erik Huelsmann

For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.5.27/README.md

1.5.26 Released

Submitted by LedgerSMB_Team on Sun, 09/29/2019 - 12:25

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
This release contains the following fixes and improvements:

Changelog for 1.5.26

  • Work around unloadable backups being dumped on some PostgreSQL version combinations (Erik H)

Erik H is Erik Huelsmann

For installation instructions and system requirements, see
https://github.com/ledgersmb/LedgerSMB/blob/1.5.26/README.md