1.2

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:

Which versions do you support?

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

Active support

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

  • 1.6: Planned End-of-life date: 2021-06-10 (released: 2018-06-10)
  • 1.7: Planned End-of-life date: 2022-10-04 (released: 2019-10-04)
  • 1.8: Planned End-of-life date: 2023-09 (to be released 2020-09)

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

Riverbend Community Math Center - Dean Serenevy

Submitted by ehu on Fri, 06/29/2012 - 08:40

We are a US not-for-profit (http://riverbendmath.org/) using SQL-Ledger and LedgerSMB since 2006 (I'm not sure exactly when we made the switch). We are a small organization: ~15 part-time employees; ~$150,000 annual revenues; 2 users of the ledger. We are still using 1.2.x because my trial transition to 1.3.x did not work out as smoothly as I had hoped. Thus, I have put the transition on hold until I can give it a few days attention. As an organization we believe in and use open source software almost entirely. 

How do I migrate from SQL-Ledger?

Submitted by Anonymous (not verified) on Sun, 03/25/2012 - 01:59

A lot of people are wondering how to manage their migration to LedgerSMB from SQL-Ledger. While there is no one simple answer that will suit everyone's situation, there is some general advice.

First thing to know is - you are among friends. LedgerSMB is built on a community of people who want to see the software and it's users succeed. Information is freely shared, and as long as you are prepared to have a go at helping yourself, we are happy to jump right in and help you do that!

We now have a mailing list, whether you are actively working on migrating to LedgerSMB or even if you are staying with SQL-Ledger for now and want some friendly community support, join up the User List to get SQL-Ledger to LedgerSMB migration help

The best course of action depends on your situation: