Re: Database restore fails

["Joshua D. Drake" <..hidden..>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wed, 28 Nov 2007 12:32:24 -0500
Paul Bente <..hidden..> 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
> ..hidden..
> 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-----