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

Collapse
Posted by Steve Manning on
You'll probably have to start using compression or split the output file using a pipe and the split command:

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

- Steve