All Versions

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:

I want to switch to LedgerSMB, but I have unpaid invoices. What to do?

Submitted by ehu on Mon, 06/29/2020 - 11:33

The general approach is to migrate invoices first, creating them as they exist in the current accounting solution. Then, differences with the intended balance can be calculated and the remainder posted at-once. For more comprehensive explanation see How do I migrate my existing books to LedgerSMB?

Which versions do you support?

Submitted by ehu on Sun, 12/30/2012 - 03:17

Active support

Versions 1.7 and higher are under active development and are supported by the community. Planned end-of-life dates for current releases are:

  • 1.7: Planned End-of-life date: 2022-10-04 (released: 2019-10-04)
  • 1.8: Planned End-of-life date: 2022-09-04 (to be released 2020-09-04)
  • 1.9: Planned End-of-life date: TBD (based on release date; to be released)

End of life

If you're looking for help on how to use EOL-ed versions, please try mailing the users mailing list.
If you're looking for someone to create bugfixes, please check with one of the parties providing commercial support or for less urgent fixes LedgerSMB Issues

Version 1.6 has been declared end-of-life on 2021-06-10. The last release in the series is 1.6.33. No further releases will be made by the community.

Version 1.5 has been declared end-of-life on 2019-12-23. The last release in the series is 1.5.30. No further releases will be made by the community.

Version 1.4 has been declared end-fo-life on 2017-09-16. The last release in the series is 1.4.42. No further releases will be made by the community.

Version 1.3 has been declared end-of-life on 2015-12-23. The last release in the series is 1.3.47. No further releases will be made by the community.

LedgerSMB versions 1.0, 1.1 and 1.2 won't be maintained any further due to the fact that there are some known security issues which can't be fixed.

Matrix and IRC Support

Submitted by Anonymous (not verified) on Wed, 12/26/2012 - 11:21
Interactive help can often be found in our chat room. Often, this is the best way to find help, both for complex questions as for quick questions and answers. This page explains your options for setting up connections as well as explains how to best ask questions. There are other non-native English speakers in the rooms; please feel free to join!