[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Database restore fails
- Subject: Database restore fails
- From: Paul Bente <..hidden..>
- Date: Wed, 28 Nov 2007 12:32:24 -0500
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.