Assuming you have followed the How Do I Backup My Data instructions, you can restore your database as follows...
Note LedgerSMB versions prior to version 1.9.16 did not support PostgreSQL 14 or higher due to a backward incompatible change in PostgreSQL 14.
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:
One creates a backup of the content of your database. The other creates a backup of the roles.
Company database upgrades are supported all the way back from 1.4 directly to 1.8, using the 1.8 software. Company database upgrades from 1.3 and 1.2 are also supported, but due to the different nature of the upgrade process are called "migrations". The important difference being that when doing a migration, a copy of the data is being created in the 1.8 structure, while upgrades adjust the existing structure for 1.8.
There are two strategies in migrating your books to between accounting solutions in general:
There are two steps to upgrading a LedgerSMB 1.6.x installation to 1.6.y (x smaller than y):
The last step has to be executed for each company database that's set up.
Note that all the steps below are prefixed with the 'sudo' command, but these can be executed as 'root' directly as well.
This is by far the easiest part. These are the steps to go through, assuming an installation from tarball:
I had created a second database. To delete it, do I just drop the database from postgresql?
On a GNU-ish *nix platform use the script:
tools/delete-company-database.sh
it'll remove the roles and the database.
Sql ledger has the option to add a barcode to a part.
In 1.4, you will be able to add a barcode per make/model record.
How are barcodes added when using LedgerSMB?
Sort term solution:
It's not optimal for a UPC management but it solves the immediate problem:
Add a space separated list with the barcodes to the partnumber field
The partnumber is the "Number" filed on the same line as "Description" in the "Add Part" page.
And yes, "space separated list" works in the POS interface. (If you scan one of the codes in the space separated list )
There are a number of possible causes for login problems. Some of the more common causes are:
Login in 1.3.x is new. Take a look at this screen guide:
http://www.ledgersmb.org/help/install/Ubuntu_Installation_Tutorial_Ledge...