Peter Eisentraut <peter_e@xxxxxxx> writes: > Am Dienstag, 7. März 2006 11:13 schrieb Poul Møller Hansen: >> Is there a way to make pg_dump use /var/tmp as a temporary filespace >> instead ? > Try export TMPDIR=/var/tmp. Also, unless you have a really good reason to be using -Ft dump format, I'd recommend -Fc format instead. It's better tested and doesn't suffer from various limitations of the tar format, notably the need for a temp file. regards, tom lane
