Re: pg_dump large-file support > 16GB

From: Rafael Martinez Guerrero <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: Michael Kleiser <mkl(at)webde-ag(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump large-file support > 16GB
Date: 2005-03-17 14:38:26
Message-ID: 1111070306.6434.114.camel@bbking.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2005-03-17 at 15:05, Michael Kleiser wrote:
> I found on http://www.madeasy.de/7/ext2.htm (in german)
> ext2 can't have bigger files than 16GB if blocksize is 1k.
> Ext3 is ext2 with journaling.
>
[............]

We use 4k. And as I said, we can generate files bigger than 16GB with
other programs in the same filesystem.

From tune2fs:
---------------------------------------------------------------
tune2fs 1.32 (09-Nov-2002)
Filesystem volume name: <none>
Last mounted on: <not available>
Filesystem UUID: 80ecbce4-dcef-4668-ae84-887de850ed57
Filesystem magic number: 0xEF53
Filesystem revision #: 1 (dynamic)
Filesystem features: has_journal filetype needs_recovery
sparse_super large_file
Default mount options: (none)
Filesystem state: clean
Errors behavior: Continue
Filesystem OS type: Linux
Inode count: 5128192
Block count: 10240000
Reserved block count: 102400
Free blocks: 10070728
Free inodes: 5128097
First block: 0
Block size: 4096
Fragment size: 4096
Blocks per group: 32768
Fragments per group: 32768
Inodes per group: 16384
Inode blocks per group: 512
---------------------------------------------------------------

Regards.
--
Rafael Martinez, <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
Center for Information Technology Services
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rafael Martinez Guerrero 2005-03-17 14:46:07 Re: pg_dump large-file support > 16GB
Previous Message go 2005-03-17 14:11:34 rserv question