In the admin guide, under the section "Large Databases" is the
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.
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.
You might want to qualify that with "Operating systems which support
64-bit file sizes (such as NetBSD) will have no problem with large
databases" or "some operating systems are limited to 2-gigabyte files
(such as linux)"
pgsql-docs by date
|Next:||From: Tatsuo Ishii||Date: 2000-12-27 23:36:41|
|Subject: Re: About PQsetClientEncoding(),"SET NAMES",and "SET
|Previous:||From: Chih-Chang Hsieh||Date: 2000-12-27 11:55:47|
|Subject: About PQsetClientEncoding(),"SET NAMES",and "SET CLIENT_ENCODING"|