[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Database restore fails



Ledgersmb-1.2.9 + latest AA.pm, CT.pm, OE.pm, and Sysconfig.pm; PostgreSQL 8.2.4; Mac OSX 10.4.10 Use System > Backup > Save to File to create a backup file. Attempt to restore the database failed as follows:

postgres$ pg_restore -d compbdata /Users/pfb/Accounting/LedgerSMB/ Backups/compbdata-1.2.0-20071120.sqlc pg_restore(24895) malloc: *** vm_allocate(size=3154120704) failed (error code=3)
pg_restore(24895) malloc: *** error: can't allocate region
pg_restore(24895) malloc: *** set a breakpoint in szone_error to debug
pg_restore: [archiver] out of memory

Setting the pg_restore -a flag to just restore the data and not the schema gives the same result.

The database is pretty small with only a few Vendors, Customers, Parts, Invoices and Transactions and the .sqlc file is 124,220 bytes.

Trying an earlier .../compbdata-1.2.0-20071116.sqlc file (120,224 bytes) with even fewer database entries resulted in the pg_restore process taking all available processor load (~80%) with similar error messages until I killed the process after ~30 min.

Any ideas on how to troubleshoot this? I can't go much farther with ledgersmb until I have a reliable backup / restore.