Skip site navigation (1) Skip section navigation (2)

Re: Restoring a pg_dump fails with

From: Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restoring a pg_dump fails with
Date: 2001-05-09 09:43:10
Message-ID: 3AF9112E.8D5C4833@wettzell.ifag.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hello Tom!

Sorry for coming up again with the same problem:
COPY FROM fails with "Memory exhausted in AllocSetAlloc(40)"

After inserting all the data fields by INSERTs I activated  the
following
script by 'psql -e wetter < wetter.sql':

wetter.sql contains the following:

COPY wetter to '/Postgres/backup/h.h';
ALTER TABLE wetter RENAME TO o_wetter;
DROP INDEX wetter_pkey;
DROP INDEX idx_wetter_epoche;
DROP INDEX wetter_wetter_sensor_id_idx;
--
CREATE TABLE "wetter" (
	"sensor_id" int4 NOT NULL REFERENCES sensoren_an_orten,
	"epoche" datetime NOT NULL,
	"wert" float4 NOT NULL,
        PRIMARY KEY (sensor_id,epoche));
REVOKE ALL on "wetter" from PUBLIC;
GRANT ALL on "wetter" to "postgres";
CREATE INDEX wetter_epoche_idx ON wetter(epoche);
CREATE INDEX wetter_sensor_id_idx ON wetter(sensor_id);
--
--
COPY wetter FROM '/Postgres/backup/h.h';
SELECT count(*) FROM o_wetter;
SELECT count(*) FROM wetter;

Now:
The statement "COPY wetter FROM '/Postgres/backup/h.h';"
ends with 
"ERROR:  copy: line 1638280, Memory exhausted in AllocSetAlloc(40)"

PostgresLog says:
May  9 09:21:45 sweaty postgres[584514]: [10] DEBUG:  copy: line
1315779, XLogWrite: new log file created - consider increasing WAL_FILES
May  9 09:23:27 sweaty postgres[584514]: [11] ERROR:  copy: line
1638280, Memory exhausted in AllocSetAlloc(40)
May  9 09:23:27 sweaty postgres[584514]: [11] ERROR:  copy: line
1638280, Memory exhausted in AllocSetAlloc(40)
May  9 09:23:27 sweaty postgres[584514]: [12] DEBUG: 
AbortCurrentTransaction

This done under Postgres Version 7.1.1
There is no further Trigger, Rule or something.

I hope this helps!

--
Mit freundlichen Gruessen / With best regards
   Reiner Dassing

In response to

Responses

pgsql-admin by date

Next:From: Mauricio de CastroDate: 2001-05-09 14:24:47
Subject: Books
Previous:From: John PagakisDate: 2001-05-09 05:44:28
Subject: Adding columns to existing tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group