Peter Eisentraut <peter_e@gmx.net> 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