Re: [GENERAL] Large files on linux

2000-12-12 Thread Fernan Aguero
>Bruce Momjian wrote: > >This has nothing to do with PostgreSQL. We don't need large files to go >over 4gig tables. We split them on our own. >Peter Eisentraut wrote: > >But, unless you do chunking, it _does_ affect dumpfile size. Someone >posted awhile back a script that did dumpchunking. Sh

Re: [GENERAL] Large files on linux

2000-12-12 Thread Peter T Mount
Quoting Fernan Aguero <[EMAIL PROTECTED]>: > Dear all: > > I am having trouble with large files on a Linux box (RH 6.2). I know > there > is a limit of 2 GB on the file size, but do not know if this is kernel > related, filesystem related or both. IIRC Partly Kernel, Partly FileSystem. For la

Re: [GENERAL] Large files on linux

2000-12-11 Thread Lamar Owen
Peter Eisentraut wrote: > Fernan Aguero writes: > > I am having trouble with large files on a Linux box (RH 6.2). I know there > > is a limit of 2 GB on the file size, > ...but that doesn't affect table size, database size, or whatever you're > thinking of. Nope, PostgreSQL segments nicely for

Re: [GENERAL] Large files on linux

2000-12-11 Thread Hans-Jürgen Schönig
Alfred Perlstein schrieb: > * Fernan Aguero <[EMAIL PROTECTED]> [001211 12:45] wrote: > > Dear all: > > > > I am having trouble with large files on a Linux box (RH 6.2). I know there > > is a limit of 2 GB on the file size, but do not know if this is kernel > > related, filesystem related or both

Re: [GENERAL] Large files on linux

2000-12-11 Thread Peter Eisentraut
Fernan Aguero writes: > I am having trouble with large files on a Linux box (RH 6.2). I know there > is a limit of 2 GB on the file size, ...but that doesn't affect table size, database size, or whatever you're thinking of. -- Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e

Re: [GENERAL] Large files on linux

2000-12-11 Thread Alfred Perlstein
* Fernan Aguero <[EMAIL PROTECTED]> [001211 12:45] wrote: > Dear all: > > I am having trouble with large files on a Linux box (RH 6.2). I know there > is a limit of 2 GB on the file size, but do not know if this is kernel > related, filesystem related or both. Afaik it's both. Honestly Postgre

Re: [GENERAL] Large files on linux

2000-12-11 Thread Trond Eivind GlomsrØd
Fernan Aguero <[EMAIL PROTECTED]> writes: > I am having trouble with large files on a Linux box (RH 6.2). I know there > is a limit of 2 GB on the file size, but do not know if this is kernel > related, filesystem related or both. > > I am researchiing the issue (having some trouble to find inf