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

Submitted by LedgerSMB_Team on Sun, 05/02/2021 - 10:28

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

  • Improve upgrades in light of files attached to transactions (Erik H, #5405)

Erik H is Erik Huelsmann

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

1.6.30 Released

Submitted by LedgerSMB_Team on Sun, 03/21/2021 - 05:13

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

  • Fix Number not updated by 'Save as New' on order and quote (Erik H, #5356)
  • Performance improvements through added database indexes (Erik H)

Erik H is Erik Huelsmann

1.6.29 Released

Submitted by LedgerSMB_Team on Sun, 01/31/2021 - 11:10

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

  • Disable the broken-on-orders Schedule button on orders (Erik H, #5295)
  • Fix several LedgerSMB 1.3 migration issues (Erik H)
  • Fix dates on weekly-entry timecards (Richard W, #5336)

Erik H is Erik Huelsmann
Richard W is Richard T. Weeks

1.6.28 Released

Submitted by LedgerSMB_Team on Mon, 12/14/2020 - 22:43

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

1.6.27 Released

Submitted by LedgerSMB_Team on Sun, 09/27/2020 - 11:55

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

  • Fix sales person failing to save on AR/AP Transactions (Aung ZW, 5115)
  • Fix 'Manager' drop down not populated in employee page (Erik H, #5125)
  • Fix contact screen buttons populating customer on invoice/... (Erik H, #932)

Aung ZW is Aung Zaw Win
Erik H is Erik Huelsmann

1.6.26 Released

Submitted by LedgerSMB_Team on Fri, 09/18/2020 - 00:46

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

1.6.25 Released

Submitted by LedgerSMB_Team on Sun, 09/13/2020 - 12:18

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

1.6.24 Released

Submitted by LedgerSMB_Team on Fri, 09/04/2020 - 12:15

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