From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Chaminda Jayawardana <wpgchaminda(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #5444: Database Backup Restore - Out of memory problem |
Date: | 2010-05-01 11:34:50 |
Message-ID: | AANLkTinNrcaCcSDGXxxol8HsFXDoJaHUddDCx7FuTIWl@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Fri, Apr 30, 2010 at 4:37 AM, Chaminda Jayawardana
<wpgchaminda(at)gmail(dot)com> wrote:
> The following bug has been logged online:
>
> Bug reference: 5444
> Logged by: Chaminda Jayawardana
> Email address: wpgchaminda(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-05-01 15:36:57 | Re: PostgreSQL 8.4 - dumping database connection privileges |
Previous Message | Russell Smith | 2010-05-01 09:31:51 | PostgreSQL 8.4 - dumping database connection privileges |