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.Elphick@lfix.co.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