pg_dump error - filesystem full

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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

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.

Thanks, it takes much longer time, but the filesize is only 1/5 of the
tar size, so it's ok.
Also great with the TMPDIR hadn't thought about that.

Poul

=?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= <freebsd@pbnet.dk> writes:

Also, unless you have a really good reason to be using -Ft dump format,
I'd recommend -Fc format instead.

Thanks, it takes much longer time, but the filesize is only 1/5 of the
tar size, so it's ok.

If you're more concerned about time than space, I think you can turn off
the compression that -Fc format uses by default.

regards, tom lane