Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
> Am Dienstag, 7. Mrz 2006 11:13 schrieb Poul Mller 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