On Fri, Apr 30, 2010 at 4:37 AM, Chaminda Jayawardana <wpgchami...@gmail.com> wrote: > 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.
That sort of sounds like a corrupted dump file to me. Are you restoring it on the same machine you took the dump on, or a different one? Maybe you did something like FTP it in ASCII mode? Just guessing here, really... ...Robert -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
