Forum OpenACS Q&A: pg_dump max file limits?
it seems that i have reached some sort of limit in dump file size at 2147483647 bytes. all my nightly dumps stay at this level until i manually shrink the database, afterwhich it starts to grow again, and top out once again.
was wondering if there is a setting that needs to be done for me to dump a database larger than this. or if there is a better method to backup a database.
thanks in advance.
This issue is not specific to postgresql. Linux filesystems have a 2 GB file size limit.
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?
pg_dump yourdb | split -b 1024m - yourdb_
which will create 1Gb files called yourdb_aa, yourdb_ab, yourdb_ac etc.
Then you can import them using cat:
cat yourdb_* | psql yourdb