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

Submitted by LedgerSMB_Team on Wed, 01/22/2020 - 13: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.18

  • Upgrade Dojo dependency to 1.13.5 (Erik H)
  • Prevent dead-locks in response to request from timed out session (Erik H)

Erik H is Erik Huelsmann

1.6.17 Released

Submitted by LedgerSMB_Team on Thu, 12/26/2019 - 09:59

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

  • Allow uploading of attachments with unknown mime-types (Erik H)
  • Fix formatting on-hand (OH) column on orders to follow user settings (Erik H)
  • Fix migration of assembly data from SQL Ledger 3.2 (Yves L)

Erik H is Erik Huelsmann
Yves L is Yves Lavoie

1.6.16 Released

Submitted by LedgerSMB_Team on Fri, 11/29/2019 - 02:56

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

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

Subscribe to 1.6