1.6

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.6.15 Released

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

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

  • 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.6.14 Released

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

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

  • 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.6.13 Released

Submitted by LedgerSMB_Team on Fri, 10/18/2019 - 05:19

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

  • Generate unique names for backups (Erik H)
  • Fix incorrect tax checkmarks in contact screen after save (Erik H)
  • Fix tax accounts inclusion in posted AR/AP transactions (Erik H)

Erik H is Erik Huelsmann

1.6.12 Released

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

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

  • 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.6.12/README.md

1.6.11 Released

Submitted by LedgerSMB_Team on Sun, 08/18/2019 - 14:23

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

1.6.10 Released

Submitted by LedgerSMB_Team on Sun, 01/20/2019 - 07:37

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

1.6.9 Released

Submitted by LedgerSMB_Team on Wed, 12/26/2018 - 03:30

The LedgerSMB development team is happy to announce yet another new
version of its open source ERP and accounting application.
Please note that this version fixes an bug where unsuspecting users
could make accounting mistakes: sales taxes not correctly included
in the amount due for purchase invoices. The bug is present in all
1.5 version prior to 1.5.24 and all 1.6 releases prior to 1.6.9.
Also note that AP Transactions are not affected by this bug and
have been working correctly in 1.5 and 1.6 releases.