Forum OpenACS Q&A: Re: pg_dump max file limits?

Collapse
Posted by Ryan Gallimore on
Hi Vincent,

This issue is not specific to postgresql. Linux filesystems have a 2 GB file size limit.

See:
http://linuxmafia.com/faq/VALinux-kb/2gb-filesize-limit.html

Ryan

Collapse
Posted by Steve Manning on
It doesnt have to be a filesystem limit. I just checked one our our large nightly dumpd and its 2.9Gb. This particular machine is a 2.4 kernel with ext3 running pg 7.3.4.

I think its something to do with Large File Support in the kernel and whether the LFS is utilised by the program. We have another machine with the same kernel etc. and it hit the 2gig limit on the log file it was writing. Perhaps someone who knows about these things could explain why this would be?

- Steve