On Mon, Nov 12, 2012 at 7:56 PM, Rolf Stöckli <[email protected]> wrote: > Some technical background: If you create a backup of a L123 database with > original SQL-Ledger, the additional columns in the existing tables cause > problems because they are present in the data section of the backup, but not > in the section where the tables are created. This means the restore crashes > at the moment where the system tries to read back these values.
As I said in my last reply if you copy sql/Pg-custom_tables.sql (which is Dieter's recommended way to change the database for custom information) from ledger123 into sql-ledger, all is fine and restore procedure does not crashes. Alternative, if you take backup with pg_dump, you don't even need to copy sql/Pg-custom_tables to your sql-ledger sql folder. Regards Armaghan _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
