The following bug has been logged online: Bug reference: 5444 Logged by: Chaminda Jayawardana Email address: wpgchami...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs