Michael Graff writes:
> In the admin guide, under the section "Large Databases" is the
> following paragraph:
>
> Since Postgres allows tables larger than the maximum file size
> on your system, it can be problematic to dump the table to a
> file, since the resulting file will likely be larger than the
> maximum size allowed by your system. As pg_dump writes to the
> standard output, you can just use standard *nix tools to work
> around this possible problem.
>
> This is a generalization of, most likely, a failing in linux.
The actual maximum file size of a system at hand is irrelevant to the
correctness of the cited paragraph. Postgres will still allow tables
larger than the maximum file size and the illustrated approaches to
dumping still apply.
> NetBSD (which I use) will allow file sizes up to 2^64 -- I don't think
> anyone has generated a postgresql database that large yet.
Possibly, but how is this relevant to what *could* be done?
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/