2GB file limit. - Mailing list pgsql-general

From Arsalan Zaidi
Subject 2GB file limit.
Date
Msg-id 001301c191d2$0a25e5a0$4301a8c0@directi.com
Whole thread Raw
Responses Re: 2GB file limit.
Re: 2GB file limit.
List pgsql-general
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.

Thanks in advance.

--Arsalan

-------------------------------------------------------------------
People often hate those things which they do not know, or cannot understand.
--Ali Ibn Abi Talib (AS)


pgsql-general by date:

Previous
From: Tommi Mäkitalo
Date:
Subject: Re: libpq: possible to get list of tables, fields, and types?
Next
From: Jean-Michel POURE
Date:
Subject: Re: PostgreSQL GUI