Upgrades

Note: Hosted customers are always upgraded to latest releases.

New sql-ledger releases come out with passage of time. It is easy to upgrade to new versions. Here is how you can do it.

Important: Backup your dataset and your sql-ledger installation folder. This will allow you to restore and try again if any thing goes wrong during upgrade.

Download and untar the latest sql-ledger-x.xx.tar.gz over your existing installation.

This should be all you need to upgrade if there is not schema change. If there is some schema change (tables or columns added in new version), these changes will be applied once your first login after upgrade.

• Move to your sql-ledger installation folder

cd /usr/local/sql-ledger/

• Download and run latest setup.pl:

   wget http://sql-ledger.org/source/setup.pl
   perl setup.pl

setup.pl will lookup the latest version and will offer something like following:

(u)pgrade to 2.8.11

(i)nstall 2.8.11 (from Internet)

(d)ownload 2.8.11 (no installation)

Type 'u' to upgrade your installation.

Sometimes dataset upgrade fails with an error message when you login after application upgrade. System is locked down. The best course of action in this case is:

• Remove the nologin file from users folder to unlock the system.

• Restore your previous backup and try again by rectifying the error encountered.

You probably might need to manually upgrade your dataset by running the appropriate Pg-upgrade* scripts from sql folder.