Re: 2GB file limit.

From: Marko Kreen <marko(at)l-t(dot)ee>
To: Arsalan Zaidi <azaidi(at)directi(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 2GB file limit.
Date: 2001-12-31 09:08:23
Message-ID: 20011231090823.GA10974@l-t.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 31, 2001 at 01:36:17PM +0530, Arsalan Zaidi wrote:
> 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.

Those programs dont use O_LARGEFILE when opening? (man 2 open)

--
marko

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-12-31 09:23:49 Re: 2GB file limit.
Previous Message Arsalan Zaidi 2001-12-31 08:06:17 2GB file limit.