Re: Restoring a pg_dump fails with

Tom Lane wrote:
>
> Reiner Dassing <dassing(at)wettzell(dot)ifag(dot)de> writes:
> > By upgrading von PostgreSQL 6.5.3 to 7.1.0 I restored a dump file by
> > psql dbname <dbname.dump
>
> > After some time I get the following message:
> > ERROR: copy: line 1638280, Memory exhausted in AllocSetAlloc(56)
> > PQendcopy: resetting connection
>
> That shouldn't happen. Could we see the dump file? (Just the schema
> commands, not the data itself...)
>
> regards, tom lane
Dear Tom!

Thank you for your help. Certainly I will give this short schema:

\connect - postgres
...
CREATE TABLE "wetter" (
"sensor_id" int4 NOT NULL,
"epoche" datetime NOT NULL,
"wert" float4 NOT NULL);
REVOKE ALL on "wetter" from PUBLIC;
GRANT ALL on "wetter" to "postgres";
COPY "wetter" FROM stdin;
8 Thu Mar 02 02:34:02 2000 GMT -0.4
10 Thu Mar 02 02:34:02 2000 GMT 95
3 Thu Mar 02 02:34:02 2000 GMT 193.6
11 Thu Mar 02 02:34:02 2000 GMT 97.7
2 Thu Mar 02 02:34:02 2000 GMT 251.5
13 Thu Mar 02 02:34:02 2000 GMT 940.9
1 Thu Mar 02 02:34:02 2000 GMT 283.2
6 Thu Mar 02 02:34:02 2000 GMT 0.8
....
\.

I have witten a script to convert these COPY statements to INSERTs
and this worked! But it took a long time during night time.

--
Mit freundlichen Gruessen / With best regards
Reiner Dassing

---------------------------------------------------
| Bundesamt fuer Kartographie und Geodaesie
| Fundamentalstation Wettzell
| Sackenrieder Str. 25
| D-93444 Koetzting
|
| Tel: (+49) (0)9941/603-112
| Fax: (+49) (0)9941/603-222
| Zentrale: (+49) (0)9941/603-0
| E-mail: dassing(at)wettzell(dot)ifag(dot)de
| URL: http://www.ifag.de
---------------------------------------------------