Re: 2GB file limit.

On Mon, 2001-12-31 at 08:06, Arsalan Zaidi wrote:
> Hi.
>
> I'm trying to COPY a rather large file (> 3GB) into a db. Unfortunately, the
> COPY command throws an error telling me that the file is too large. I can
> operate on the file using 'wc', 'cat' and even through Java, but when I try
> and use vi to open it, it is automatically deleted.
>
> What's up with this? Why can some programs access the file and others like
> Postgresql and vim, not? I'm using 2.4.17 with ext3 on an x86 machine.

I don't know why COPY and vi barf on it, but if you can use things like
wc on it, try piping it into psql:

psql -d your_database -c "COPY your_table FROM STDIN" < very_big_file

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"Ye have heard that it hath been said, Thou shalt love
thy neighbour, and hate thine enemy. But I say unto
you, Love your enemies, bless them that curse you, do
good to them that hate you, and pray for them which
despitefully use you, and persecute you;"
Matthew 5:43,44