=?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= <[EMAIL PROTECTED]> 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 conce
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,
Peter Eisentraut <[EMAIL PROTECTED]> 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
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/
---(end of broadcast)--
/tmp: write failed, filesystem is full
pg_dump: [tar archiver] could not write to tar member (wrote 0,
attempted 101)
Is there a way to make pg_dump use /var/tmp as a temporary filespace
instead ?
Thanks, Poul
---(end of broadcast)---
TIP 9