From: | Garrett Dangerfield <dangerimp(at)cox(dot)net> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | copy problem |
Date: | 2004-02-12 22:04:05 |
Message-ID: | 20040212220405.OCIH11482.fed1mtao07.cox.net@smtp.west.cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Not sure if this is a bug or not, but it seems like one.
I am trying to load a data file into a table using the copy command.
When I do it on a small subset of the data (gotten using the Linux head command) it all works fine, but when I run it on the full dataset, I get the following error:
ERROR: repalloc: invalid request size 1073741824
WARNING: AbortTransaction and not in in-progress state
message type 0x5a arrived from server while idle
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The file I'm trying to load has 57,063,476 rows in it and the file is 8,786,592,005 bytes long.
Do I need to break the file I'm trying to load up, are there other options?
I'm running this on Redhat Shrike Linux 9 on an Intel 2.4GHz processor w/ 1.25G of RAM and I've got over 500GB of storage total, with over 130GB free.
Thanks,
Garrett Dangerfield.
From | Date | Subject | |
---|---|---|---|
Next Message | SZŰCS Gábor | 2004-02-13 17:16:47 | 7.4 aggregate OR TRUE yields strange results |
Previous Message | Harry Hochheiser | 2004-02-12 20:21:34 | Default Timestamp 'Now' bug with 7.4 on Panther. |