David Rickard <David.Rickard@GTScompanies.com> writes:
> 1) We suspect that pg_dump is using tmpfile while writting the export file:
I believe this is true when you use the tar output format. The simplest
solution is to use custom format instead (-Fc instead of -Ft).
> is this true? and if so, how do we (can we?) control where tmpfile writes
> during the export process?
AFAIR you can't change it without hacking the source code.
regards, tom lane