BUG #5444: Database Backup Restore - Out of memory problem - Mailing list pgsql-bugs

From Chaminda Jayawardana
Subject BUG #5444: Database Backup Restore - Out of memory problem
Date
Msg-id 201004300837.o3U8b2LA051016@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5444: Database Backup Restore - Out of memory problem  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5444
Logged by:          Chaminda Jayawardana
Email address:      wpgchaminda@gmail.com
PostgreSQL version: 8.3
Operating system:   Windows Server 2003
Description:        Database Backup Restore - Out of memory problem
Details:

I have postgres sql database backup file around 1.4GB size. when I'm trying
to restore it, it is giving a following error message.

pg_restore: restoring data for table "cms_gib_image"
pg_restore: restoring data for table "cms_imagess"
pg_restore: [custom archiver] out of memory
pg_restore: *** aborted because of error

Process returned exit code 1.

generally we are taking weekly backups of our production server
databases(All the databases are Postgres sql 8.3) but now we are facing
problem of restore them.
Please advise us how to resolve this database restore problem.

Thanks
Chaminda Jayawardana

pgsql-bugs by date:

Previous
From: "Claudio"
Date:
Subject: BUG #5443: Undetected deadlock situation
Next
From: Martin Pitt
Date:
Subject: Re: [9.0beta5/cvs head] build failure due to unchecked results