Backup

We back the server up off-site eight times a day, and you can take your own copy at any moment without asking us.

• Download a full backup of your dataset from the dashboard, on demand.
• The backup is a PostgreSQL dump — restorable anywhere, by anyone.
• Eight off-site backups a day on top of that, kept encrypted.
• The in-application backup (System › Backup) can be emailed to you rather than downloaded.
• Need to roll back? Send us one of your backups and we restore the dataset from it.

Where to find it Dashboard › Backup  ·  System › Backup

Taking a copy

1. Open the control panel dashboard, find the dataset and press Backup. A PostgreSQL dump of the whole dataset (pg_dump custom format, named after the dataset and the time) is prepared and downloaded. Up to five backups an hour can be taken this way.
2. To restore, send the file to us at support.ledger123.com and we load it; the dataset is replaced as at the moment of the dump. Anywhere else, the file restores with pg_restore.
3. Our own off-site backups run eight times a day regardless.

From inside the application

1. System › Backup › Save to File downloads a SQL dump of the dataset through the browser; Send by E-Mail mails it to the address in your Preferences.
2. To restore that SQL dump elsewhere: create an empty database, load the dump with psql, and copy the templates folder alongside. That is all a SQL-Ledger dataset is.

From the blog

• Cloning SQL-Ledger dataset — Sometimes you need to create a new dataset with exact same customers, vendors, items, chart etc. from an existing dataset.
• Free forever SQL-Ledger Hosting — tl;dr: Signup here: https://account.ledger123.com/ From today we are offering free forever SQL-Ledger hosting. You can signup and create as many databases as you want to.