dbTalk Databases Forums  

[BUGS] BUG #1890: ERROR pg_restore archiver out of memory

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] BUG #1890: ERROR pg_restore archiver out of memory in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Arso - Italy
 
Posts: n/a

Default [BUGS] BUG #1890: ERROR pg_restore archiver out of memory - 09-19-2005 , 10:15 AM







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 ?

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.