1.4

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.

Upgrade to LedgerSMB 1.6 (from 1.5 or 1.4/starman)

Submitted by ehu on Sat, 05/26/2018 - 03:19

Upgrading tarball installations

There are two steps to upgrading a LedgerSMB 1.5.x to 1.6:

  1. Upgrade the software
  2. Upgrade the company database

The last step must be executed for each company database that's set up.

These steps also apply when upgrading a 1.4 installation running Starman. To upgrade 1.4 installations not running on Starman, or to upgrade from earlier versions, please see Upgrading to Ledgersmb 1.5. Note that the default configuration for 1.4 runs CGI, not Starman.

1.4.42 Released (end-of-life release)

Submitted by ehu on Sat, 09/16/2017 - 14:02

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application. This will
be the last release in the 1.4 series, which has reached End-Of-Life
(EOL) status on September 15, 2017; after three full years of active
maintenance. The fact that the release series has reached EOL status
means that no further community supported releases will be
created - except for translation updates when available. Users are

1.4.41 Released

Submitted by ehu on Sun, 04/09/2017 - 13: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.4.41

1.4.40 Released

Submitted by ehu on Tue, 03/14/2017 - 12:24

The LedgerSMB 1.4.39 release identifies itself as a development version due
to a mistake in the release process. This release corrects that situation
and contains exactly one additional change:

Changelog for 1.4.40

  • Fix name of the sequence being updated in the 1.3 migration script (Erik H)

Erik H is Erik Huelsmann

1.4.39 Released

Submitted by ehu on Mon, 03/13/2017 - 13:31

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application. This release
contains a fix for the change in Perl 5.24 which no longer includes '.'
in @INC. Some distributions have backported this change to earlier Perl
versions (as it is security fix CVE-2016-1238). LedgerSMB now both works
correctly without '.' on @INC and actively removes '.' from @INC on any

1.4.38 Released

Submitted by ehu on Sun, 01/22/2017 - 02:45

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.4.38