BUG #1890: ERROR pg_restore archiver out of memory

From: "Arso - Italy" <arso(at)libero(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1890: ERROR pg_restore archiver out of memory
Date: 2005-09-18 21:49:39
Message-ID: 20050918214939.1C6E4F0CB1@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1890
Logged by: Arso - Italy
Email address: arso(at)libero(dot)it
PostgreSQL version: 8.0.3
Operating system: Linux Gentoo
Description: ERROR pg_restore archiver out of memory
Details:

The error on pg_restore happen restoring a small table dumped with 7.4.5.
the definition is:

CREATE TABLE mais
(
mais_progre int4 NOT NULL DEFAULT nextval('mais_progre_seq'::text),
mais_accoun varchar NOT NULL,
mais_msgmd5 varchar NOT NULL,
mais_msguid int4 NOT NULL,
mais_dtaric timestamp NOT NULL,
mais_dtamsg timestamp NOT NULL,
mais_frommm varchar NOT NULL,
mais_subjec varchar NOT NULL,
mais_messag varchar,
mais_dtaprt timestamp,
mais_destin varchar,
CONSTRAINT mais_primary PRIMARY KEY (mais_progre),
CONSTRAINT mais_accoun_msgmd5 UNIQUE (mais_accoun, mais_msgmd5)
)
WITH OIDS;

The size dump file is 2073Kbyte, so is not BIG.
Before upgrading to 8.0.3 on the restoring host ther was installed the SAME
postgres version of the dumped host. The error happen too in this
situation.

How I can obtain more information for resolve the problem ? Is a bug ?

Browse pgsql-bugs by date

  From Date Subject
Next Message Elmival de Sousa 2005-09-19 11:15:29 BUG #1891: Out Of Memory.
Previous Message Tom Lane 2005-09-18 04:02:48 Re: BUG #1889: little documentation error