-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 28 Nov 2007 12:32:24 -0500 Paul Bente <[EMAIL PROTECTED]> wrote:
> 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. This is clearly a PostgreSQL issue and possibly a bug based on the malloc error (although the bug might be in glibc). Please post this to pgsql-hackers with the same description. Sincerely, Joshua D. Drake > > 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. > > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTac+ATb/zqfZUUQRAshqAJ4yuSsUgvpi1/HQ936fEZfrRHmqTwCfX7hc deICiEbNPEIFKsdU2OJHIVU= =Khtp -----END PGP SIGNATURE----- ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
